Report showing sys_ID instead of name

[chandan15]

Hi, I have a "Multi-level pivot table type" report on table "resource_allocation_daily". Where it is supporting only 5 rows and 3 column.

So I want to populate 2 field value by concat with below function in report:-

"glidefunction:concat(u_project_detail, " - ",user)"

Here "user" is a reference field, so the new value is showing sys ID instead of user name. (getDisplayValue()) is not supporting in Report->Configure Fuction Field.

Can anyone suggest how can populate user name instead of sysID......!!

[AndersBGS]

Hi Chandan,

I think that when only selecting user due to the reference for sys_user table, it will show the SYSID. use user_name or similar depending on how you have sorted your user with sys_user table.

/Anders

[chandan15]

I am not able to DotWalk or type any field name which is not present in the form....

[NIkhil Chaurasi]

Hi Chandan,

You can use user.user_name

Regards 

Nikhil