How to add the Multi row variable set in the report including all the RITM Variables

[Aishwarya37]

We have created database view on sc_req_item and sc_multi_row_question_answer.
Currently we are getting all multirow variables on report, but we want to show all variables present on RIMT also, including multirow variables also. 

[Sumanth16]

Hi @Aishwarya37 ,

You can actually report on MRVS by creating a database view, then use that view to report on

1. Create a new Database view (System Definition -> Database Views)
2. 1. Give it a name like 'u_sc_req_item_multi_var'
   2. Label like "Multi Row Variable Set"
   3. Plural like "Multi Row Variable Sets"
   4. Description like "Joins the sc_req_item to the Multi Row variable set table to be able to report"
3. Save
4. Under View Tables click "New"
5. 1. Table: Requested Item [sc_req_item]
   2. Variable Prefix: sci
   3. order: 100
   4. Where clause: mrqa_parent_id = sci_sys_id
   5. Click "Submit"
6. Under View Tables click "New"
7. 1. Table: Multi Row Question Answer [sc_multi_row_question_answer]
   2. Variable Prefix: mrqa
   3. order: 100
   4. Where clause: keep this field blank
   5. Click "Submit"

You should now have a DBV that looks something like this:

Create a new report

Select Table as source and select your new Database view (Multi Row Variable Set) as the table 

You should now be able to create a query and select the catalog item that you want to report on that has the MRVS, as well as adjust your columns to display the Question and Value as well as any other columns you want on your report.

Referred from this thread :https://community.servicenow.com/community?id=community_question&sys_id=252bce56dbd363809a64e15b8a96...

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[Aishwarya37]

Hi @Sumanth16 ,
I tried database view but now below issue is happening while creating report. So in report same variable(from multi row variable set) is showing 3-4 times. please let us know how to filter out duplicates.