Reports - Catalog Item

Community Alums
Not applicable

How can we create a report on a specific catalog item where we want the data to be populated based on the Variables.

Catalog Item - XYZ

Variable - Var1 , Var2 , Var3 ,Var4

 

Use Case - Create a Report where the report shall have the columns , Column 1 - Var1 , Column 2 - Var2 and so on.

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Community Alums,

 

In general you can create a report (if we are looking for the RITMs) based on the sc_req_item table where condition is the item:

AndersBGS_0-1729577194299.png

 

Add the column for variables and select the specific variable:

AndersBGS_1-1729577242637.png

Based on this the variables will be visible in the report:

AndersBGS_2-1729577294500.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

Hi @Community Alums,

 

In general you can create a report (if we are looking for the RITMs) based on the sc_req_item table where condition is the item:

AndersBGS_0-1729577194299.png

 

Add the column for variables and select the specific variable:

AndersBGS_1-1729577242637.png

Based on this the variables will be visible in the report:

AndersBGS_2-1729577294500.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/