CiviCRM Community Forums (archive)

We have Business Memberships and if a Business becomes a member, we give them four (4) free memberships for their staff.

If I pull a report on Business Memberships I only want the Business Member Organizations to show up in the count and report - not the staff that works for them.

For example if I have 3 Business and Business A has 2 members; Business B has 4 members and Business C has just 1 member. When I pull report I would want the report to just list 3 Business Members, not 7 and not 10 (in my reports now, I get the businesses themselves counted (so 3) and also the staff (so 7) that shows up as a total 10.

Any suggestions on best way to set  this up?

I also need to be able at anytime to look up Business A and see how many memberships are tied to that business and who those members are.

I didn't use auto inherit when I created the membership type AND membership reports do NOT offer a choice for primary or related members.