Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

custom field values not showing in exported report

Avatar

Level 2

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 2

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 2

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