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

[absadik]

Hello Community,

I created a database view to join the MRVS and Requested Item tables. However, in my report, I’m unable to find the requested item variables to add as columns. Has anyone encountered this issue or know how to resolve it?

Thank you!

[Brian Lancaster]

Can you provide screenshot of how you setup your database view?

[Brad Bowman · Accepted solution]

Here's a Database View that joins the RITM, variable, and MRVS tables.  With this approach you get one row of data for each MRVS variable / variable / RITM combination, so it can be overwhelming in a report

[absadik]

Thank you it works, I appreciate your help!