Count of records in related list in report

[Poorva Bhawsar]

Hi Community,

I need to create a report in which when I apply filter for vendor (manufacturer) it should show related business applications like how many business apps are associated with the filtered vendor, then how many servers those business apps have, and then how many vulnerable items those servers have. Count of VITs means number of related list rows or records.

How to create report for this?

[Community Alums]

Hi @Poorva Bhawsar ,

Interesting question !! For this requirement, you can use Function Field which will get what you're looking for, but still involves adding a field to a table.

Refer to this doc  :Configuring function fields

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi @Poorva Bhawsar ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Poorva Bhawsar]

Did you got my requirement?

I need to show vendor name in the first column, then associated business apps, then how many servers are there for those business apps and then vulnerable items count (related list under server table).

I dont know about the table as well, getting confused a lot.

How to do this?

[Poorva Bhawsar]

And this function field feature is not applicable for database views.