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 would add some additional formatting to clean up the "more", "less" hyperlinks so that incase that there is no data in field and/or if the field if less than 100 characters the "more" or "less" doesn't show up.
If([field]="","",If(Length([field])>100,
var Text a = Left([field],100);
var Text b = NotLeft([field],100);
$a &
" <a onclick=\"$(this).hide();$(this).next().show().next().show();\">More</a>" &
" <span style='display:none'>" & $b & "</span>" &
" <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Less</a>",[field]))
The underlined code in this page is copyright by Dan Diebolt and may not be used without including my phone number (734-985-0721) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it.
If([field]="","",If(Length([field])>100,
var Text a = Left([field],100);
var Text b = NotLeft([field],100);
$a &
" <a onclick=\"$(this).hide();$(this).next().show().next().show();\">More</a>" &
" <span style='display:none'>" & $b & "</span>" &
" <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Less</a>",[field]))
The underlined code in this page is copyright by Dan Diebolt and may not be used without including my phone number (734-985-0721) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it.