how do report on multi row variable set

MMKK
Tera Expert

Hi All,

I wanted to know if there is any way that i can report on Multi row variable set variables. I really need this feature and i see that there is some limitation.

Please share any alternate way.

26 REPLIES 26

Hello Kevin,

Thanks for your suggestion , I have tried it as below and getting error.

 

Please suggest.

 

Thanks,

Samarendra Nayak

Hi,

 

I am not able to call MRVS in report by using data base view in servicenow. Is there any other way to call in report?

 

Regards,

Naresh s

The only way to report on MRVS is to create a Database View. If you can't use the new table in reports, you need to check your ACL's. Non admins will have to have a read ACL on the DB view to see/use it.

Hi Kevin,

 

I have admin role, i can access the all DB views,

 

Thanks,

Naresh

 

KaMmILa__
Tera Expert

We have a similar requirement , Thanks for all the info above, I am able to report using the above mentioned solution but we have a reference field where the values in that are displaying as sys_ID , is there a way we can get the values for that instead of sys_id ?

 

We tried to create a string field and on change/selection of the reference field the value is  copied from that reference field to string field , using this we can see the values in the report but we are not able to hide the string field from the form as there is a limitation from servicenow( we don't want to show the same field twice on the form)

 

Is there any alternate solution for that ?