Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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 ?