Looking to change the Role IDs in a report grouping to the actual Primary Role name...

[TaylorKa]

Hey all, I'm trying to adjust the grouping names in a report from the Role ID to the Primary Role. In text mode, is there a way to translate the ID to the name that actually makes sense for the viewers? Any help would be appreciated!

[TerryHy]

Hi Taylor, yes. Just change wherever it says "roleID" to "role:name". So for the below, valuefield=roleID, would be valuefield=role:name. This will work for any report where you want to change ID to Name; you would just need to change where it says ID to :name

displayname=

linkedname=direct

namekey=roleID

querysort=roleID

valuefield=roleID

valueformat=HTML

[TaylorKa]

Thanks so much for the help! Unfortunately this is a method I've already tried with no luck.

This is the string now:

group.0.linkedname=owner

group.0.namekey=view.relatedcolumn

group.0.valuefield=owner:roleID

group.0.namekeyargkey.0=owner

group.0.namekeyargkey.1=roleID

group.0.valueformat=string

group.1.linkedname=direct

group.1.namekey=Department/Location

group.1.valuefield=Department/Location

group.1.valueformat=customDataLabelsAsString

textmode=true

[TerryHy]

What type of report are you trying to run (User, Task, etc.)?

[TaylorKa]

Sorry, it is an issue report

[TerryHy · Accepted solution]

In your group.0, change: group.0.valuefield=owner:roleID to the following:

group.0.valuefield=owner:role:name

And change: group.0.namekeyargkey.1=roleID to the following:

group.0.namekeyargkey.1=role:name

I tested this out with an Issue Report and I got results grouped by the role name.

[TaylorKa]

Thanks so much for your help, I really appreciate it! 🙂 Have a great weekend!