Reporting on SCTASK table - specific catalogue item and Incident table in same report

[Trish Mac]

I need to be able to report on the SCTASK table  a particular catalogue item and select Variables from that catalogue item, as well as on the Incident table, to produce a report on both Request and Incident tickets assigned to a particular assignment group.   However, I'm not able to choose Variables unless I choose a List type and a report with multiple datasets needs to be a type of any of bar, horizontal bar, line, column, area, or spline reports according to my understanding.

This seems to make this impossible to achieve, as I need to be able to have the Choose Columns ability which none of the above report types provides.   Does anyone have a method to achieve this?

Thanks,

Trish

[Dr Atul G- LNG]

Hi @Trish Mac 

As you mentioned the catalogue item and Incident , both are 2 different table an there is nothing common to fetch the results. So even i am thinking database view also not work here.  So the requirement is not possible case or do u have specific field on catalog item which refer to Incident?