I want to join the 3 table data in one report

Mohd abdul khad
Tera Contributor

I have three different table, which I want to create a report of that 3 different table in one report

can someone help me in these

 

Thanks 

khadeer

3 REPLIES 3

J Siva
Tera Sage

Hi Khadeer,

If any one table has a reference of other two tables, then you can create a database view and then you can create a report on the database view.

Please share the table details, so that I can give more info on that.

Thanks, 

Siva

Viraj Hudlikar
Giga Sage

Hello @Mohd abdul khad 

You can do by creating a database view and then do report on that database view table.
Below are some videos which will tell you how to create DB view:
https://youtu.be/_JY462TmXxU?si=4_t2xSiFOlECZ-8H

https://youtu.be/vk1MYBxTSxY?si=eHrxiFuT2am82unA

 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

In this ServiceNow Tutorial, Aaron Elder gives a demo on creating and using a database view in ServiceNow. Create the database view. Role required: admin. Learn more: https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/task/t_CreateADatabaseView.html ...

Ankur Bawiskar
Tera Patron
Tera Patron

@Mohd abdul khad 

which 3 tables?

If you have common fields between those 3 tables or common fields between those tables then it will be easier to join

what did you start with and what didn't work?

There are lot of OOB database views which joins 3 tables. Did you check those?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader