Add a program field to a task level report

[lizpowell]

Hello! Is there a way to add a program level field (this is a program data point that is a custom form) into a column of a task level report?

I tried copying the text mode (below) of the column in a project level report, but it did not work.

displayname=
linkedname=program
namekey=view.relatedcolumn
namekeyargkey.0=program
namekeyargkey.1=PIM | RHC TShirt Size
querysort=DE:program:PIM | RHC TShirt Size
textmode=true
valuefield=program:PIM | RHC TShirt Size
valueformat=customDataLabelsAsString

[Rafal_Bainie]

I think, This cannot be done directly, program is 2 steps away from task (via project).

If you had a field on project that would carry over that data from program, than you could include that in the task report

[RandyRoberts · Accepted solution]

Substitute "name" with your desired program field.

displayname=Program
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=program:name
querysort=project:program:name
textmode=true
valuefield=project:program:name
valueformat=HTML

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

[lizpowell]

This worked! 

Here is the exact info I used.

displayname=Program RHC Tshirt Size
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=program
namekeyargkey.1=program:PIM | RHC TShirt Size
querysort=project:program:PIM | RHC TShirt Size
textmode=true
valuefield=project:program:PIM | RHC TShirt Size
valueformat=customDataLabelAsString

BUT I am now running into an issue where that field is blank when I export to excel. There is info in the field in Workfront, but when I export, the field is blank. Any solutions for this? I already tried removing the column then re-adding.