Limiting Characters in Reports

[justjill853]

I just wanted to share this because it helped us so much! We share Status Updates in some reports and it made the reports appear much longer than they were due to long comments. Tony helped us by providing this text edit to limit characters in a column to 200. Thanks Tony !! displayname= linkedname=direct namekey=description querysort=description textmode=true valueexpression=LEFT({description},200) valueformat=HTML Jill Blum Stanley Black & Decker, Inc.

[NRYNR]

Here's a similar "summary" I use for updates: displayname=Latest Update namekey=latest update textmode=true valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}))) valueformat=HTML