SQL error on custom property in report writer

Steve_Pfister

 I'm trying to create a variation on a built-in Availability report to include a text custom property in the Nodes db called Notes. When I try to set it up, I get:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator

How can I get this working? I'm not sure where I can specify IS NULL or LIKE, and I'm not comparing or sort this field as far as I can see...

 

Thanks!

 

tdanner

Report Writer is putting the Notes field into the GROUP BY clause in the SQL query. This isn't your fault - it's just the way the availability report works.

The database 'text' type (Custom Property Editor refers to it as 'Memo') is nice because it's virtually unlimited in length, but it has these limitations in how you can query with it. Could you make do with a varchar field? (Custom Property Editor calls this 'Text' - confusing, I know.) You can set the length to something pretty big, like 500 characters. Then the reports would work for you.