My event has a structure of all participants pairing up in study couples (2 or 3 people together). I know I can create a relationship for each one, but I need to see the pairs very clearly in the event participant list. How can I show the list of participants grouped by pairs, or even have each 2 (or more) coupled participants highlighted in different colors?

2 Answers 2


You can get somewhat close to your desired functionality by putting the contacts in a smart group and displaying them within the relationship report.

  1. Use the advanced search to display all contacts within the event (by adjusting the search fields within ("Events").
  2. Add all the contacts to a new smart group.
  3. Create a new report to show relationships (Administer > CiviReport > Create new report from template > Relationship report).
  4. In "Filters", set "Group" to your smart group.
  5. Adjust other report settings as necessary.

But I suspect the end result will still not be 100% satisfying. Groups of three might not display well enough for you.

  • Great, thank you. And now the only thing missing is to add to this report some custom fields that are related to the participants of the event. How can I do this? Because these fields do not appear in this report template's Columns options.
    – Elad
    Aug 30, 2017 at 17:33

I would recommend creating a custom report for this. It will require some PHP coding, but will give you the level of control you seek.

  • If you need help creating a custom report, you can hire one of the CiviCRM experts. My company Left Join Labs is on that list and you can reach me at sean (at) leftjoinlabs (dot) com.
    – Sean
    Aug 30, 2017 at 14:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.