How to create a Report on a table, along with its Related List Table ?

[AbdurRahmanSnow]

Good morning.
I have a requirement to create a Report on a particular table called Vendor (core_company), and inside its each record, there are associated Applications (cmdb_ci_appl) which can be more than 1.  
How should I create a report on this?

The screenshot shows only for a particular Vendor record. Like this, I need to create a report for all the Vendors records along with their associated Applications.
I just want to show Columns such as: Vendor Name, its associated Applications and their count of each application for each Vendor name. Please help.
I want to see it like below screenshot:

[Voona Rohila]

Hi @AbdurRahmanSnow 

Create a List report on Applications table and GroupBy Vendor Field.

You can add additional conditions as required - Vendor || is not empty

https://www.servicenow.com/docs/ja-JP/bundle/yokohama-now-intelligence/page/use/reporting/concept/li...

[AbdurRahmanSnow]

Thank you Rohila for your valuable reply. How do I also show the count, as mentioned in above screenshot?

[Voona Rohila]

The count cannot be shown separately, but once you do groupBy Vendor field, It shows the count of Applications.

[Ankur Bawiskar]

@AbdurRahmanSnow 

in your report filter conditions you can use Related list conditions

what did you start with and where are you stuck?

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