Answers.Body: <p>In latest versions of CiviCRM searchkit should do this.</p>
  <p>Participant search&gt; Event Name and Status</p>
  <p>Link contact details from Participant record&gt; Child Data</p>
  <p>Parent Details&gt; Bring in related contacts from child record</p>
  <p>This demo from a meetup is as good an intro to Searchkit as I've found
  <a href="https://civicrm.org/blog/wmortada/searchkit-new-way-get-data-out-civicrm" rel="nofollow noreferrer">https://civicrm.org/blog/wmortada/searchkit-new-way-get-data-out-civicrm</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-06-16T10:15:58.207Z
Answers.LastActivityDate: 2022-06-16T10:15:58.207Z
Answers.UserDisplayName: Craig Almond
Answers.Body: <p>Probably your best option for this would be to use the data processor extension, which allows you to present related information on the same screen. You can then add options to PDF/CSV export if it needs downloading.</p>
  <p><a href="https://civicrm.org/extensions/data-processor" rel="nofollow noreferrer">https://civicrm.org/extensions/data-processor</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-06-16T08:15:07.390Z
Answers.LastActivityDate: 2022-06-16T08:15:07.390Z
Answers.UserDisplayName: Parvez Saleh
Body: <p>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.</p>
  <p>I want to create a report that lists each child and includes:</p>
  <ul>
  <li>Child's Contact ID,</li>
  <li>Child's name,</li>
  <li>Child's birthdate,</li>
  <li>Child's Event's name,</li>
  <li>Child's Event status (for example 'Registered'),</li>
  <li>Child's custom field data (for several custom fields),</li>
  <li>Parent's Contact ID,</li>
  <li>Parent's name,</li>
  <li>Parent's emails,</li>
  <li>Parent's phone numbers,</li>
  </ul>
  <p>I can create reports for all of the Parent's data.
  I can create reports for a Child's data (events and custom data).</p>
  <p>I cannot figure out how to create a report in civi that includes both. How is that possible? What am I missing?</p>
  <p>I am using CiviCRM 5.45.6  on Drupal 8</p>
  
Tags: <relationships><reports><custom-reports>
Title: Create report including data from contact and from related contact
ThreadText: # Create report including data from contact and from related contact
  
  (Asked by: username_0 on 2022-06-16)
  
  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
  
  **Tags:** relationships, reports, custom-reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-06-16. Score: 2
  
  In latest versions of CiviCRM searchkit should do this.
  
  Participant search> Event Name and Status
  
  Link contact details from Participant record> Child Data
  
  Parent Details> Bring in related contacts from child record
  
  This demo from a meetup is as good an intro to Searchkit as I've found
  <https://civicrm.org/blog/wmortada/searchkit-new-way-get-data-out-civicrm>
  
  
  ---
  
  ### Answer by username_2 on 2022-06-16. Score: 1
  
  Probably your best option for this would be to use the data processor extension, which allows you to present related information on the same screen. You can then add options to PDF/CSV export if it needs downloading.
  
  <https://civicrm.org/extensions/data-processor>
  
  
  ---
  
  