Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts. Register and secure your Critical IT infrastructure
Crystal Reports Removes Characters from Memo Fields
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
📖HomeBack 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.