I have contacts who are parents and related to contacts who are children. Child is registered for an event. Parent is not registered for any event.
I want to create a report that lists each child and includes:
- Child's Contact ID,
- Child's name,
- Child's birthdate,
- Child's Event's name,
- Child's Event status (for example 'Registered'),
- Child's custom field data (for several custom fields),
- Parent's Contact ID,
- Parent's name,
- Parent's emails,
- Parent's phone numbers,
I can create reports for all of the Parent's data. I can create reports for a Child's data (events and custom data).
I cannot figure out how to create a report in civi that includes both. How is that possible? What am I missing?
I am using CiviCRM 5.45.6 on Drupal 8