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

[JTGrosjean]

I think I am in the same spot as you right now. I believe that the problem is that each of your Project Number variables is technically a different variable (different sys_id) that happens to share the same name. I'm trying to do something similar with a Campus field (at a college with 3 campuses) and I want to do a report that groups by the campus. 

I originally thought it would just pull the campus value, but the report is tricky, it actually just won't show the catalog items for the other versions. 

Try using a variable set? you would have to rework all your items, but maybe that gives you a single variable to report on. 

If you do anything else with the individual variables of name "project number", then you might have a new problem there. 

[Dr Atul G- LNG]

Hi @Community Alums 

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?