custom field values not showing in exported report

[KristenS_WF]

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.

[KristenS_WF · Accepted solution]

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