In Civicrm in Contact reports I used the template called Relationships. Our data is as follows:
We have Household Members, those members reside in a Residential Community(in our cases Caravan Parks with a unique name) and those Residential Communities are then grouped into branches.(example Ballina Branch)
So after checking the following report settings:
Contact A Full Name
Contact B Full name
Then set the following Filters: Contact Type A is one of Residential Community, then Contact Type B is one of Household
the report shows the contact A is for example Ballina Caravan Park(which is the Residential Community Name) then Contact B is Mr and Mrs Smith(which is the Household name) however when trying to filter by the Group(which is the Branch Name) the report generates no information. Remove the Group and the report shows all Households in every Residential Community across all 17 branches. I cant seem to narrow the filter to a specific branch using the group filter.
Any ideas if im making a mistake?
Thanks so much...lost too much hair already!