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
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!!
Reply all
Reply to author
Forward
0 new messages