I want to join the 3 table data in one report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2025 07:32 PM - edited 02-05-2025 07:35 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2025 04:17 AM - edited 02-08-2025 04:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2025 04:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2025 07:12 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader