How to create report from 2 different tables

[Sonali01]

Trying to create a report from 2 different tables, but no luck.
Please help.

Thanks

[Tai Vu]

Hi @Sonali01 

Let's try this approach below.

1. Create your report for the first table under Time Series type. Ex: Incident [incident]

2. Create a dataset for the second report.

3. Define table and condition for the dataset. Ex: Requested Item [sc_req_item]

Enjoy. Let me know if it works for you!

Cheers,

Tai Vu

[Shekhar Navhak1]

Have you tried database view? If not please check document: https://docs.servicenow.com/en-US/bundle/vancouver-application-development/page/use/reporting/concep...

[Danish Bhairag2]

Hi @Sonali01 ,

You can create a Database view by merging those two tables & then create report on the merged table which we call it as database view table.

Plz go through below video to see how we can achieve it.

https://youtu.be/_JY462TmXxU?si=8H-4LxGkyT6BJqny

Mark my answer helpful & accepted if it helps you achieve your requirement.

Thanks,

Danish

[Ankur Bawiskar]

@Sonali01 

either use Data set approach as mentioned or use database view