


Hi All,
I created a task report. Originally I inserted a column to display the program name for the projects containing the tasks listed in the report:
displayname=Program
querysort=project:program:name
textmode=true
valuefield=project:program:name
valueformat=HTML
This works fine, but I noticed that many of the program names are long and a little unwieldy. I ended up creating a program-based custom form with a field for a shortened program title. I then created a new column in the report:
displayname=Program Short
querysort=DE:project:program:CAT Learning Program Short Title
textmode=true
valuefield=DE:project:program:CAT Learning Program Short Title
valueformat=HTML
The values from the custom field appear when I run the report. However, when I export the report (either to Excel or pdf) the column is blank. Does anyone know what's happening here? Is there a different coding I should use to get this custom field to export successfully?
Thanks.
Views
Replies
Sign in to like this content
Total Likes
Ah... changed it to this, and the values now export properly:
displayname=Program Short
textmode=true
valueexpression={project}.{program}.{DE:CAT Learning Program Short Title}
valueformat=HTML
Views
Replies
Sign in to like this content
Total Likes
Ah... changed it to this, and the values now export properly:
displayname=Program Short
textmode=true
valueexpression={project}.{program}.{DE:CAT Learning Program Short Title}
valueformat=HTML
Views
Replies
Sign in to like this content
Total Likes