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