Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!
SOLVED

custom field values not showing in exported report

Avatar

Level 6

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.

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

1 Reply

Avatar

Correct answer by
Level 6

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