Expand my Community achievements bar.

SOLVED

Manager Name in Hour report

Avatar

Level 1

Hi,

I have an hour report that I would like to add the manager name so we can filter or sort.  I am able to pull in the manager id for a user but not seeing a field for a name.  Does anyone know how the manager name can be shown instead of the id?

 

Thanks

 

Heather

1 Accepted Solution

Avatar

Correct answer by
Level 6

Hey @HTSchlegel - 

 

You can change any ID to a Name by using Text Mode. Edit your report, click your ID column, Click "Switch to Text Mode" in the top right, then paste this in.

displayname= Manager Name
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=managerID
querysort=owner:managerID
textmode=true
valuefield=owner:manager:name
valueformat=HTML

 

On a user or project level report (where you are not jumping databases) can simply revise the "managerID" to be "manager.name" to get the same effect. 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 6

Hey @HTSchlegel - 

 

You can change any ID to a Name by using Text Mode. Edit your report, click your ID column, Click "Switch to Text Mode" in the top right, then paste this in.

displayname= Manager Name
linkedname=owner
namekey=view.relatedcolumn
namekeyargkey.0=owner
namekeyargkey.1=managerID
querysort=owner:managerID
textmode=true
valuefield=owner:manager:name
valueformat=HTML

 

On a user or project level report (where you are not jumping databases) can simply revise the "managerID" to be "manager.name" to get the same effect. 

Avatar

Level 1

Hi Daniel,

That worked perfectly!   Thanks so much.

 

Heather