Shorten the displayed text in a report | Community
Skip to main content
T
ThomasNe2
Level 4
November 30, 2023
Solved

Shorten the displayed text in a report

  • November 30, 2023
  • 1 reply
  • 2262 views

One of our teams uses a custom form which request descriptions which can be rather long.

I have built a report to summarise information submitted on the custom form which contains the description fields. I have included a screenshot to illustrate an example of the length.

Is there a way to limit the amount of detail shown in the report details tab without removing this column? A way so only, for example, half of the content is shown?

Best answer by ajdifonzo

Hi Doug

 

Thanks for your response. 

 

I haven't been able to affect the result with what you advised.

 

I have attached screenshots here. 

 

Thomas


This should do it. 

 

valueexpression=LEFT({DE:Please tell us what you would like},150)

1 reply

ajdifonzo
ajdifonzo
Level 3
November 30, 2023

Hi, 

You can use the following to limit what is show. Since you noted the description field that is what I used.  The 25 would be the number of characters you would like to show. 

 

valueexpression=LEFT({description},25)

 

If this helps, please mark as correct so it can help others. 

T
ThomasNe2Author
Level 4
November 30, 2023

Thanks for your response. 

I have pasted this in but it results in the column becoming completely blank. 

The title of the column concerned is 'Please tell us what you would like' and I also replaced this in the coding you sent but the result is the same and the column shows blank. 

Any ideas?

ajdifonzo
ajdifonzoAccepted solution
Level 3
November 30, 2023

Hi Doug

 

Thanks for your response. 

 

I haven't been able to affect the result with what you advised.

 

I have attached screenshots here. 

 

Thomas


This should do it. 

 

valueexpression=LEFT({DE:Please tell us what you would like},150)

    Terms & ConditionsAccessibility statement

    Loading footer...