Database View for displaying variables from a variable set in a catalog item as columns in a report

[ZamSol]

Hello everyone, 

I'm trying to find a solution to displayi variables from a variable set in a catalog item as columns in a report and then add it to a dashboard. I already created one but in this case each variable from the variable set ends up as a row in the list report.

Current report:

Database View configuration:

What I would like to achieve is to have 1 row for each record of the ritm table (sc_req_item) and then to have as columns the variables from the variable set of the catalog item. Any help for achieving this? 

[Brad Bowman]

A Database View will ALWAYS show one row for each record on all of the joined tables.  There is not a way to report on variables and their values that are part of a multi row variable set since there will / could be more than one row of variables for each RITM record / row.  A workaround is to script the contents of the MRVS into a new or re-purposed multi-line text variable then display that on the report.  You can use an onSubmit script to populate this new variable when each request / RITM / Catalog task is submitted or updated, and a Fix Script to populate the ones already submitted.

[ZamSol]

Hi @Brad Bowman  ! Thank you for the support. 
Right now I'm using a single row variable set, does that change anything? is it still the same scenario as if i were using a MRVS?

[Brad Bowman · Accepted solution]

For variables in a single row variable set, you would just select them in the 'Choose columns' section of the report, just like variables that are not in a variable set.