How to Report a set of Catalog Task (SCTASK) and their variables together in a report?

[RAJJYOTI]

How to Report a set of Catalog Task (SCTASK) and their variables together in a report?

The fields of SCTask and the variable names should be each column of the report.

[palanikumar · Accepted solution]

Hi,

You can do this in Reporting Module:

1) Goto Reports > Create New

2) Give some Report name and select Catalog Task as table

3) In Type leave current selection (List) and click Next

4) In Configure, Click "Choose Column" button

5) You will see variables in the Available list as last entry. Scroll down and click (refer below screenshot)

6) After clicking the Variable click the expand button available above the right and left arrow (refer below screenshot)

7) You will get the list of catalog item. Select the catalog which you want to pull. 

😎 Now the variable are listed. Select the variables required in the report and click ok

Let me know if you face any issue

Thank you,

Palani

[RAJJYOTI]

Thanks a lot . It was so easy 🙂

[JagjeetSingh]

Hi,

This will be more like a list view of the sc task records. Anyways, below is how you can create it.

Create report on sc_task table. Type= Multi-level pivot table.

In configure tab, select "number" in rows and add other variables in columns(you can select maximum of 3).

if you want to see more than 3 columns then you can use report type= list. Select all the fields you want to see there in configure tab.

Mark my response correct or helpful if it works for you. Ask for help if required.