Can I collapse a text field on reports?
Is there is a way to collapse a multi line text field when it is displayed on reports? For example, a Description field can get pretty detailed and can make a report that displays it rather large and...
Forum Discussion
I use this code for these kinds of problems.
If(Length([Comments])>100,Left([Comments],100)&"...<br><a href="&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10>more</a>",[Comments])
Change the 100 to represent the number of characters that you need to display in the report before the "more" button becomes visible.
(Remember to turn on the HTML in the Formula Text field) - usually I label these fields [Comments (Reports)] so it is more obvious which fields should be used for report building
If(Length([Comments])>100,Left([Comments],100)&"...<br><a href="&URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]&"&dfid=10>more</a>",[Comments])
Change the 100 to represent the number of characters that you need to display in the report before the "more" button becomes visible.
(Remember to turn on the HTML in the Formula Text field) - usually I label these fields [Comments (Reports)] so it is more obvious which fields should be used for report building