There are some limitations to the CiviCRM searching and reporting. For example, you might have a set of organizations that are tagged "Not For Profit" and you want to list all the employees of those organizations, grouped by each organization.
Such a search or report is not possible in CiviCRM without customization.
We will use the power of Drupal Views to create a relationship report. We will also expose the tag and relationship filter so that our report is dynamic.
In Drupal, navigate to Structure | Views and add a view. Call it
Relationship and Tag report
.Set Show to CiviCRM contacts.
Click on Continue and Edit to continue and edit the view.
Remove the CiviCRM Contact ID field.
Add the CiviCRM Contact: Display Name field. The view is now showing a list of contact display names.
Add a relationship. Select CiviCRM Relationships: Contact ID A as shown in the following screenshot:
Select...