Manager Name in Hour report

Question

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

Daniel_Clarke · Accepted Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO