Manager Name in Hour report | Community
Skip to main content
H
HeatherTe
Level 2
January 28, 2025
Solved

Manager Name in Hour report

  • January 28, 2025
  • 1 reply
  • 509 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Daniel_Clarke

Hey @heatherte - 

 

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. 

1 reply

Daniel_Clarke
Community Advisor
Daniel_ClarkeCommunity AdvisorAccepted solution
Community Advisor
January 28, 2025

Hey @heatherte - 

 

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. 

    H
    HeatherTeAuthor
    Level 2
    January 28, 2025

    Hi Daniel,

    That worked perfectly!   Thanks so much.

     

    Heather

    Terms & ConditionsAccessibility statement

    Loading footer...