Has anyone successfully created a report with RITM variables and Multirow variable sets?

[MohammedYaseen]

Hi All,

I am trying to create reports with RITM and Multirow variable sets, its not coming as expected

Mutirow variable set variables are present in different table and RITM variables in different table.

I tried with some of the solution already in the community but it does not appear to work.

Can we use performance analytics or any script for this.

Customer requirement is they want to see in a table view just how it is present in multirow variable set view in Catalog form

Appreciate any quick solution or work around

@Robbie 

[Ankur Bawiskar · Accepted solution]

@MohammedYaseen 

yes this is possible

Create a report with RITM Variable Sets and Multi-row Variable Set 

Reporting on MVRS along with other Variables 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MohammedYaseen]

Thanks Ankur, I am able to get the Variable set question and answers but not the RITM variables

Also other than List report is there any other report option possible like Pivot?

[Ankur Bawiskar]

@MohammedYaseen 

you can display & fetch RITM variables directly in the report list view.

I doubt for pivot type

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MohammedYaseen]

I need RITM variables,Multirow fields and its values like a table

RITM Number - RITM XXX

RITM Variable 1   - Team - India

RITM Variable  2 - State - Karnataka

Mutirow Field question Department

Multirow field answer - IT

Muti row Field question Sub Department

Multirow answer - Networking

Mutirow Field question 3 - Training Completed

Multirow answer Yes

Output report i am looking for

RITM Number	Team	State	Department	Sub Department	Training Completed
RITMXXX	India	Karnataka	IT	Networking	Yes