Hi Can we bring related lists in reports?

[Sofiya Perumal]

Hi Experts,

In change request we have Change tasks, Impacted services in related lists. Is there any possibility to bring it in reports or using list layout ?

refer the screenshot.

need the above values in reports. Please help

Regards,

Sofiya

[shyamkumar VK]

Hi @Sofiya Perumal ,

if you want to have the both table data in single report you need to use database view for this

or if you want to design them individually , click on the filter link end and select open in new window , 

then click on the column option and select report type

[Community Alums]

Hi @Sofiya Perumal ,

Reporting includes the ability to use Related List Conditions. See below:

[Ahmmed Ali]

Hello,

You can add conditions on related list in report but cannot bring the data into report view. One workaround will be to create database view of required table and report on the database view.

Database views (servicenow.com)

Thank you,

Ali

[AndersBGS]

Hi @Sofiya Perumal ,

You have the possibility to dot-walk in reports from change task to change but not the other way around, so it comes down to what it actually is that you would like to see / report on. 

In the reporting part, if you create a report based on sc_task table which is the catalog task table, you can both filter on sc_task and sc_req_item which is the request as shown below:

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

Best regards

Anders