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.

Multi Row Variable Set values don't display in order in a report

jd3737
Tera Contributor

I'm working on building a report showing variables in a multi row variable set.  I have a database view that joins the sc_req_item table and the sc_multi_row_question_answer table.  I have the report showing the values in the MRVS, but it's not showing the info correctly.

find_real_file.png

The image above is what shows on the RITM.  I need the report to show it like this, but I can't find a way to do it.  Right now, I'm using a List report.  Below is how it came out using that RITM:

find_real_file.png

When you look at the data, the POD # fields don't correspond with the correct people.  Is there any way that I can format the report to show the data like the variable set?  If not, how can I relate the data to the correct people?

1 ACCEPTED SOLUTION

Priyanka Gupta
Mega Guru

Hi,

I think you cannot use multi row variable sets for reporting. It is mentioned here in docs. Here's a screenshot of the text for your reference.

find_real_file.png

Please mark my answer correct/helpful based on the impact.

View solution in original post

5 REPLIES 5

Radhu
Tera Contributor

Thank you @tony.lu , but i could not find Question.order in my filter

 

Thanks

Radhika