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:

[AbdurRahmanSnow]

Hi @Ankur Bawiskar , @Dr Atul G- LNG , @Voona Rohila 
I created like below on Application table (cmdb_ci_appl), but it does not show the count of each associated application like the screenshot which I have attached on the top. Please help me out.

It should look like below. How can we do it? 

[Dr Atul G- LNG]

Hi @AbdurRahmanSnow 

The format you shared in from excel sheet which is not possible in SN. You can get the count the way you are getting or try to create a pivot table type report and by dot walk try the get the count.

[AbdurRahmanSnow]

Ok Sir, sure. I will try it out. Thank you for your response.

[Dr Atul G- LNG]

Hi @AbdurRahmanSnow 

The screenshot you shared cannot be built directly in reports. You can use the Related List feature in reports to fetch only the vendor details.