how do report on multi row variable set

[MMKK]

Hi All,

I wanted to know if there is any way that i can report on Multi row variable set variables. I really need this feature and i see that there is some limitation.

Please share any alternate way.

[Tadz]

Hi upon checking the documentation there is a limitation.

Link: https://docs.servicenow.com/bundle/london-it-service-management/page/product/service-catalog-managem...

The only thing that i can think of is creating a custom table to store the values for reporting.

[Kevin133]

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.

Please mark this answer as correct or mark has Helpful if helpful.

[dj7887]

Hi Kevin,

I created report mentioned in steps. However i also want to have RITM variables on same report.

Could you please guide me to get RITM variables on report combined to Multi row set data.

Thanks,

Dhawal.

[kevinray]

Sure, but keep in mind your going to get a lot more records returned because your going to have an MRVS row for every variable now.

Add the following three rows to your database view. NOTE: You may have to add the "Left Join" column to your view and/or form (depending how you are creating these)

Assuming you use the same naming convention:

Question(sio_item_option_new) will be the label of your variable
Value(sio_value) will be the value of the variable.

[Aishwarya37]

Hi Kevin,
I tried this the same way you created. But I am facing below issue:
1.Report I received: In column Value(sio_value) , multirow variable values are not showing for Name and Email( marked in RED , and this is multirow variable set)
2. Duplicate entries are coming

3. Name and email values are getting saved in column VALUES(mrqa_value)

This is Database view:

This is our form on portal