Assistance related to report creation

[anandsuresh]

Hello Everyone,

We have a Service Catalog form that includes standard fields such as text, choice, and reference. Additionally, it contains a field that allows submission of multi-row values (MRVS – Multi-Row Variable Set).

I am trying to build a standard report that can be scheduled to automatically generate a list of all tickets raised in the previous month, to be delivered on the 1st of each month.

While creating the report using the Requested Items (sc_req_item) table, I can see only the standard field values. However, the MRVS data is not visible. After searching in Community, I found that MRVS values are stored in a separate table: sc_multi_row_question_answer

How can I combine both tables so that I can view all the data, including MRVS values, in a single report?

[Bhuvan]

@anandsuresh 

Create a database view table and report on it. You can refer below article for the steps

https://www.servicenow.com/community/platform-analytics-forum/create-a-report-with-ritm-variable-set...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[anandsuresh]

Thank you, Bhuvan. I will try the above steps and confirm back to you in 1-2 business days after checking with the team. I appreciate it.

[lauri457]

You can create a database view by joining [sc_multi_row_question_answer] to [sc_req_item] by the Parent ID field. Or you can create a remote table that queries and transforms the data from the two tables to whatever form you need (mind the row limit on remote tables). 

[anandsuresh]

Thank you, Lauri. I will try the above method, and let you know soon. Meanwhile, if the above database view method is not working as expected, I will also explore the remote table option you mentioned and confirm.