To get Variables and MRVS variables in reports

[shobhan]

Have a scenario where need to fetch the Variables and Multi Row Variables of a particular catalog item in reports.

[Dnyaneshwaree]

Hello @shobhan ,

Have to tried solutions from below articles if not then please refer below articles:
https://www.servicenow.com/community/platform-analytics-forum/reporting-on-mvrs-along-with-other-var...
https://www.servicenow.com/community/platform-analytics-forum/create-a-report-with-ritm-variable-set...
https://www.servicenow.com/community/developer-forum/data-visualization-how-to-make-reports-based-of...

[shobhan]

I tried,was able to fetch only multi row variables not all variables 

[Vishal Savajia1]

Try in this way

I want to pull MRVS variables in Database View Rep... - ServiceNow Community

Each MRVS is stored in a separate table named sc_multi_row_question_answer

Choose Tables for Database View

For Example
Add the Parent Table (e.g., sc_req_item).
Add the MRVS Table (sc_multi_row_question_answer).
Define Join Conditions:

Join the parent table and MRVS table on the appropriate key, typically the sys_id of the parent table matches the document_key of the MRVS table.

DB View should be like this: 
sc_req_item (Alias: req_item)
sc_multi_row_question_answer (Alias: mrvs)
Join Condition:

req_item.sys_id = mrvs.document_key

[shobhan]

@Vishal Savajia1 

Tired but was able to get only the MRVS and not all variables from particular catalog item