Solved Long Text in Report cuts off (1 Viewer)

Dumferling

Member
Local time
Today, 03:53
Joined
Apr 28, 2020
Messages
102
I am sure that there is something I should be doing but it is just beyond what I can remember. I have Long Text (O365 version) fields in my reports but it cuts off after what I assume is 255 characters. Both field and section is set to can grow and shrink. How do I fix this?
 

isladogs

MVP / VIP
Local time
Today, 01:53
Joined
Jan 14, 2017
Messages
18,186
The field is truncated at 255 characters it it contains any formatting.
Remove the formatting at report level or table level and all text will be shown
 

Dumferling

Member
Local time
Today, 03:53
Joined
Apr 28, 2020
Messages
102
OK. Solved it. You have to change the Totals line to "First" and not "Group By". Judging by the comments there are many ways to solve this issue - some work one way and some another. For me, for this issue it has been to change the totals to "First"
 

isladogs

MVP / VIP
Local time
Today, 01:53
Joined
Jan 14, 2017
Messages
18,186
Ah. You didn't mention the use of a Totals line in your initial post.
For info, using First (or Last) can lead to unpredictable results as tables have no inherent record order.
Recommend using Min/Max instead of First/Last
 
Last edited:

Users who are viewing this thread

Top Bottom