Crystal Reports Removes Characters from Memo Fields

[sbeadle1]

📖 Home  Back  
Crystal reports has been found to remove the second and third characters out of any memo field used in a report. This problem was mostly an issue with the two ClearSCADA fields Message (from CDBEventJournal) and NoteText (on CDBObject).

To alleviate this problem, in ClearSCADA 2007 R1 these two fields have been converted to 254 character strings. However, these can sometimes store more information than 254 characters (with the event journal it is very common), so two new fields have been added - MessageLong and NoteTextLong. These two fields are Memo fields.

If you want to use the memo fields in Crystal to ensure data returned is not truncated, create a 'SQL Expression Field' in the crystal report which uses CAST to force ClearSCADA to cast the memo to a string. For example:

CAST ("CDBObject"."NoteText" AS STRING)

You should then use the new Expression field rather than the memo field directly and the problem will be resolved.

Go: Home Back