Limit characters in a report
Is it possible to have the project description only show the first 100 (or so) characters in a task report? The purpose is to have a quicker overall view with smaller rows.
Is it possible to have the project description only show the first 100 (or so) characters in a task report? The purpose is to have a quicker overall view with smaller rows.
Yes, it's possible. This would be the code for a task report:
-----------
valueexpression=CONCAT(LEFT({project}.{description},100),"...")
valueformat=HTML
displayname=Project Description
-----------
You can omit the CONCAT() portion if you choose, so it would just be valueexpression=LEFT({description},100). The CONCAT is just there to add "..." to the end of the description, that way a user knows that there may be more text that they're just not seeing in the report.
If you want to get REALLY fancy and only add the "..." when the description is > 100 characters, you'd use this formula:
-----------
valueexpression=IF(LEN({project}.{description})>100,CONCAT(LEFT({project}.{description},100),"..."),LEFT({project}.{description},100))
valueformat=HTML
displayname=Project Description
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.