Displaying trouble with Text size more than 255 characteres
5 views
Skip to first unread message
Mohamed Cisse
unread,
Feb 4, 2026, 12:54:23 PMFeb 4
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to reportman
Hello, I have trouble displaying text in report manager. I use postgres database and my field is of type TEXT.
the TRpExprresion can't show that type of field. When I check le result of my sql query, i see (MEMO) as datatype.
I converted the field to VARCHAR and that worked. Unfortunately the data is truncated when the report is displayed. I checked the reason and found that le max size of varchar is 255 characters.
I searched the function to convert (MEMO) but i couldn't find anything that met my needs. I tried using EVALTEXT but that didn't work.
Is there a fonction that can perform this conversion or another method to convert MEMO data to text that can be displayed in report manager. thanks!!