Report on Multi-Row Variable Set

[Vamsi43]

Hello

I tried report on MRVS by creating a database view.

I created a MRVS with the questions "Employee Name" (reference to sys_user) and "Salary %" (string). As you can see, for the field "Employee Name", I'm only getting the sys id (as this is saved in the "u_sc_req_item_multi_var" table), not the display value of the User name.

Can anyone help me on this??

[Ankur Bawiskar]

@Vamsi43 

that's because in the backend it stores sysId and not display value

for this you need to use database view

Create a report with RITM Variable Sets and Multi-row Variable Set 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Vamsi43]

Hello @Ankur Bawiskar 

I tried implementing the same solution where i created the database view please check the below screenshot.

It showing sys id. I have a reference variable "Employee Name" which is referring user table not the string field.

[Ankur Bawiskar]

@Vamsi43 

in the link shared is there any other enhancement which they suggested to show display value.

Possibly you might have to include those referenced table as well in database view to get display value