Reporting Question - how to report on variables found in numerous catalog items

[rachelconstanti]

I have twos reference variables that I want to report on - these are in multiple catalog items. One is called project number and the other is called approver.

I am trying to get a report that has the following:

• RITM #
• REQ #
• REQ Open Date
• SCTASK #
• Opened By
• Requested For
• Requested for Dept.
• Item
• Short Description
• Qty
• Price
• Project Number 
• Approver 

I can easily add all the fields except for Project Number and Approver.

Is there an easy way - report source or database view that will give me all this info in one report?

If these were in a variable set would that be any better?

Thank you,
Rachel

[Shubham Singh]

Hi @rachelconstanti 

You can add these variables on your report by following the below steps:

• Create a report on sc_req_item table.
• Go to Configure -> Choose columns.
• Go to bottom in Available columns and Click on Variables[+] (don’t push it to selected columns).
• Once clicked, you will get a new branch like option in between the columns. Click on it.
• Search any catalog item with that have these two variables.
• It will show all the variables of the selected catalog items.
• Push the required variables from Available to Selected columns.
• Click OK.

Condition: The variables should be defined with same backend name on all the items.

Thanks!

Please mark this response as correct and helpful ✔️👍

[rachelconstanti]

Thank you for the response - these variables are on 50+ catalog items.  

Without having to select each catalog item and then those two variables to get them on the report, what are my other options?

[Shubham Singh]

Hi @rachelconstanti 

It doesn’t matter on how many catalog items these variables are. You only have to select it once for any of those 50+ catalog items. Only condition is that the backend name of those variables should be same on all the catalog items.

Give it a try. It worked for me!

Regards,

Shubham Singh

Please mark this response as correct and helpful ✔️👍

[rachelconstanti]

All the variables are the same and yes when I select one item they display on the report however  the values of those two variables will not populate on the report unless I select each catalog item...