+ Start a Discussion
sfdeveloper9sfdeveloper9 

Reports/Query question

we have three objects A, B & C.

B and C are child objects of A. Is there an easy way in SF to find out how many A records have atleast one B record and one C record. and how many A records have only B records and not C records.

 

I know we can create roll up formula fields on A and run a query. But I don't want to create those fields unless there is no other alternative.

 

Thanks in advance.

hitzhitz

Hi,

 

By using creating a report type on object.

 

https://login.salesforce.com/help/doc/en/reports_overview.htm