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
  • 2265 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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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?

ChrisStephens
Community Advisor
ChrisStephensCommunity Advisor
Community Advisor
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


I believe you need the "DE:" in your value expression, just like it's in the querysort line.

    Terms & ConditionsAccessibility statement

    Loading footer...