+ Start a Discussion

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.




By using creating a report type on object.