custom field values not showing in exported report | Community
Skip to main content
KristenS_WF
KristenS_WF
Level 6
September 15, 2022
Solved

custom field values not showing in exported report

  • September 15, 2022
  • 1 reply
  • 596 views

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.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KristenS_WF

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

1 reply

KristenS_WF
KristenS_WFAuthorAccepted solution
Level 6
September 15, 2022

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

Terms & ConditionsAccessibility statement

Loading footer...