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

rachelconstanti
Mega Sage

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

8 REPLIES 8

Shubham Singh
Mega Guru

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 ✔️👍

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?

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 ✔️👍

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...