text,ntext,and image data types cannot be compared...

[KEHudson]

In Reportsmith, has anyone ever received the SQL Execution Error "The text,ntext, and image types cannot be compared or sorted, except when using IS NULL or LIKE operator". Is there a fix for this?

Thanks.

 

[Atrzy]

It may mean that you cannot sort on a text field or ntext field. Are you trying to sort by a text field or include a text field in a WHERE clause?

 

[KEHudson]

When I try to insert a field (job_posting_descr), this is when I get the message. I'm not trying to sort on this field, but I am sorting on at least 4 other fields. I do also have a derived field that is MAX DISTINCT with the database grouping option checked. I'm thinking this may be the problem, but I wasn't sure if there was a way around it.

Thank you for responding.

 

[CharlesCook]

Do a Derived Field:

MAX(job_posting_descr)

Then make sure that in DB Grouping job_posting_descr is not turned on.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[KEHudson]

The report seems to be working now. Thank you for the feedback.