How to call related list in report

[niksnow]

Hi, 

I was creating a report using the sc_request_metric table, where I need to display details from the sc_task table, which are available only in the related list of that record. I mean, each request has corresponding child records (request tasks) in the related list. I want to display these child task details in the parent record report. Is it possible to dot-walk to the related list?

[miftikhar20]

Hi @niksnow ,
are you creating the report from the Report Designer / Dashboard area, or generating it through scripting or a widget?

[niksnow]

I am trying through report designer 

[miftikhar20]

Hi @niksnow ,

If you want to include related list details in your report, you can set the report source table to be the related list table (for example, sc_task in your case).
Then, in the Configure tab, select the reference field that links back to the parent table (for example, Request [sc_request_metric]).

This way, your report will display the related list records along with their corresponding parent request numbers.

For Example, I tried this using the Incident table and its Affected CI related list — and it worked as expected. The report displayed the parent incident number along with the related list details.

If my response helped, please mark it as the accepted solution so others can benefit as well.   

[niksnow]

@miftikhar20 I will try this, so I need to create a report in sc_task table and in configure field I need to fetch the fields from sc_request_metric table?