Request item Report with Task

[surajsukuma]

Can we create Request item report with task details as well ? 

The business owner wants to see the Request report like below, since all are different tables, I am unable to find the option to merge all tickets in one report

Request Number	Requestor Name	Created Date	Completed date	Business Duration
	Approved Task	Created Date	Completed date	Business Duration
	SC task	Created Date	Completed date	Business Duration

Thanks in advance

[Dr Atul G- LNG]

Hi @surajsukuma 

No, everything you mentioned cannot be done on one report unless you create the database view. or create with multi dataset option. I am not 100% sure but multi data set might be helpful.

https://www.servicenow.com/docs/de-DE/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_...

[AndersBGS]

Hi @surajsukuma ,

As I understand it, you would like to see the requested item details together with approvals and task for the requested item - correct? If this is the case, then only solution would be to create a database view to combine the different tables in one view. 

[surajsukuma]

Yes thats correct. Do you have instructions to create database view, I have not done yet. 

[AndersBGS]

Hi @surajsukuma ,

Please go through the documentation to understand how to do it: https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/use/reporting/concept/c_D...