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

[Dr Atul G- LNG]

Hi @Shubham Singh 

Quick win. 

Create report on Sc_req_item table.

When you click on configure tab , you will option to choose variable , select and your work done.

or if you want to do some filter on variable

[rachelconstanti]

I have over 50 catalog items that have the variables I need to report on - how can I get a report on these without selecting each catalog item?

[Dr Atul G- LNG]

This is the only way mate. Atleast once you need to select.

[rachelconstanti]

Not even with a database view/report source?