Custom Report Column Displaying Code with Result

Question

Hi WF Community,
 
I have a project report, whereby I am trying to surface values from custom fields on related programs.  However, the result in my report custom column displays code.

Here's the text mode data for the Client Engagement Lead column:
displayname=Client Engagement Leadlinkedname=programnamekey=view.relatedcolumnnamekeyargkey.0=programnamekeyargkey.1=WF Client Engagement Leadquerysort=DE:program:WF Client Engagement Leadtextmode=truevaluefield=program:WF Client Engagement Leadvalueformat=customDataLabelsAsString
 
I played with the valueformat, but it's not seeming to make a difference.Does anyone know what adjustment I might make to just display names without the extra code?
 
Thanks,Nick

William · Accepted Answer

Good news, @nickva7

I SWEAR that I tried this before and it didn't work, but I saw it working in another environment and tried again with a fresh mind.

Caveat is that you can't do this with a calculated view. But, you can do it if you add a calculated field to your project form.

On your project custom form, add a similarly named calculated field, like "Program Principal" (presuming the field name of the typeahead on the program form is called "Principal")
The expression for your project calculated field is easy:

{program}.{DE:Principal:name}

Recalc your project expressions, then your project view/report can be built to just reference your new project-level field "Program Principal"

Tested and working. Good luck!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded