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

[jd3737]

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.

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:

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?

[Priyanka Gupta · Accepted solution]

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.

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

[jd3737]

That is unfortunate.  Thanks for the quick response!

[Radhu]

Hi @jd3737 

Have you get any solution for your  requirement?

I need same requirement, please let me know the workarounds

Thanks

[tony_lu]

This is possible.  Order your results by "Row index" and then by "Question.Order"