Is there a way to pull data from multiple tables into a single report?

Daniel A_ Woods · ‎12-13-2018

Currently we use multiple reports to pull the data for a monthly overview report. For instance, we use an Incident table to pull the closed incident counts, Incident Time Worked table to get the time worked, and the Incident SLA table to pull the data per SLA Definition. Therefore, there are 3 reports generated and pushed out to excel, then there is cutting / pasting and manual manipulation of data (Not the most productive solution).

We are looking for a way to display these KPIs on a single report. Any suggestions would be greatly appreciated.

Alikutty A · ‎12-13-2018

Hello,

Have you tried using multiple Data sets in reports? Please refer its documentation here

Thanks

Daniel A_ Woods · ‎12-13-2018

Yes, I have generated several reports using multiple data sets, but I have not had much luck seeing the data against the data sets compared to the main file. Suggestions?

JV6 · ‎12-13-2018

Yes what you're looking for is the Related List Conditions functionality in the report.

Research how it works. I believe that's exactly what you're looking for.

Here's the wiki on it: https://docs.servicenow.com/bundle/london-platform-user-interface/page/use/using-lists-v3/task/create-related-list-query.html