- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 01:36 AM
Hi community!
I'd like to know if there's a way (or if it is possible) to create a report joining RITM variable sets and Multi-row Variable sets in one report.
Solved! Go to Solution.
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 01:45 AM
HI Erika,
You can actually report on MRVS by creating a database view, then use that view to report on
- Create a new Database view (System Definition -> Database Views)
-
- Give it a name like 'u_sc_req_item_multi_var'
- Label like "Multi Row Variable Set"
- Plural like "Multi Row Variable Sets"
- Description like "Joins the sc_req_item to the Multi Row variable set table to be able to report"
- Save
- Under View Tables click "New"
-
- Table: Requested Item [sc_req_item]
- Variable Prefix: sci
- order: 100
- Where clause: mrqa_parent_id = sci_sys_id
- Click "Submit"
- Under View Tables click "New"
-
- Table: Multi Row Question Answer [sc_multi_row_question_answer]
- Variable Prefix: mrqa
- order: 100
- Where clause: keep this field blank
- 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...
Mark my answer correct & Helpful, if Applicable.
Thanks,
Sandeep
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2024 01:46 PM
Hi all, we also have the requirement to report on RITMs created w/cat items w/MRVSs.
In the screenshot example above, how do you know which set of values were submitted in a single row on the MRVS?
In other words, there is just a random list of Quantity, Description, Model Number, etc... How do you know which ones make up a row on the MRVS ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 05:52 AM
Did you find a solution for this? I have same requirement
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 07:31 AM
We did what Neil P suggested below. Thank you @Neil P.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 07:13 AM
For mine, I group by number, then sort by row index. That groups them sufficiently. An excel output of the table is a little better, sorting wise.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 05:29 AM
Hi Neil, @bostonsnow
For me below issue is happening
1. RITM variables are coming in separate column ( marked in RED) and multirow variables are coming in another column (Marked in blue)
We have created view this way: