Answers.Body: <p>If you are using Drupal, you can create a View that shows all that data. When you build the View, on the right click Advanced and in Relationships add the CiviCRM tables so you can show both Event &amp; Membership data.
  Add the Drupal Views Data Export module so you can download the results and print it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-06T03:22:32.560Z
Answers.Text: There is also Views PDF
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-08T05:07:54.177Z
Answers.Text: Both of these require Drupal, which doesn't work as we are running Wordpress
Answers.UserDisplayName: Corey Burger
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-06T03:17:00.387Z
Answers.LastActivityDate: 2019-12-06T03:17:00.387Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>Under Actions use the Export as CSV for the event and the members reports. Then copy and paste the one list with the other and sort them however you want. I know it is not one simple step within Civi but it should get you what you are looking for.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T19:05:46.067Z
Answers.Text: Not really. I don't want a manual process, I want a report that a non-technical user can print for the meeting
Answers.UserDisplayName: Corey Burger
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T06:04:46.593Z
Answers.LastActivityDate: 2019-12-02T06:04:46.593Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>I think that you can do this with the constituent detail report under contact reports.</p>
  
  <p>First of all, I think you need to create a temporary group with the people you are interested in. Find the participants for the event you want and add them to the temp group. Then find the contacts in the group you are are interested in and add them to the temp group.</p>
  
  <p>Then in the constituent detail report filter by the temp group. In the columns selection, remove all to do with contributions and activities, add email in for the contact and select other columns as you require.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T19:08:16.613Z
Answers.Text: That doesn't really work either, as you don't end up with one person per row, with columns for Membership Type, Status, End Date
Answers.UserDisplayName: Corey Burger
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T19:14:08.023Z
Answers.Text: In which case I don't think you will find what you want in an existing report and would have to write a new report.
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T19:16:04.097Z
Answers.Text: Ya. I find CiviReport to be quite clunky and not at all flexible, hence why I have both Extended Reports and Reports Plus enabled. Hopefully we will see a new structure come in the future that combines Search Builder-style functionality with the reports
Answers.UserDisplayName: Corey Burger
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-08T18:30:33.047Z
Answers.Text: I hesitate to write this because you cannot hear the tone, but...   CiviCRM is Open Source. Extended Reports and Reports Plus exist because someone saw a need and ran a campaign to fund a fix. Also Civi in general needs regular funding to keep improving. You might have to work within the WordPress/Civi communities to have a fix made. Please understand, I know nothing about you so this is not directly pointed at you. For all I know, you are the top donor to Civi. But I just wanted to take the opportunity to put in a plug on behalf of those that have made all of this possible so far. THANKS!
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-02T08:44:39.137Z
Answers.LastActivityDate: 2019-12-02T08:44:39.137Z
Answers.UserDisplayName: Mick Kahn
Body: <p>So I can easily create a Search Builder for what I want, my challenge is creating a report that I can print an take to an event</p>
  
  <p>Criteria:
  Either registered for event
  OR
  A member of a specific group</p>
  
  <p>From Contacts
  Name, Email</p>
  
  <p>From Membership
  Status, End Date (if any)</p>
  
  <p>From Event
  Registration (if any)</p>
  
  <p>The problem is that all the report templates are missing one or several of these items, or assume you only want event participants or current members.</p>
  
  <p>Am I missing something or this is a known limitation?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-06T19:16:49.017Z
Comments.Text: What CMS do you use?
Comments.UserDisplayName: petednz - fuzion
Tags: <civireport>
Title: Combining Event, Membership & Contacts into single report
ThreadText: # Combining Event, Membership & Contacts into single report
  
  (Asked by: username_0 on 2019-12-02)
  
  So I can easily create a Search Builder for what I want, my challenge is creating a report that I can print an take to an event
  
  Criteria:
  Either registered for event
  OR
  A member of a specific group
  
  From Contacts
  Name, Email
  
  From Membership
  Status, End Date (if any)
  
  From Event
  Registration (if any)
  
  The problem is that all the report templates are missing one or several of these items, or assume you only want event participants or current members.
  
  Am I missing something or this is a known limitation?
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: What CMS do you use?  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2019-12-06. Score: 3
  
  If you are using Drupal, you can create a View that shows all that data. When you build the View, on the right click Advanced and in Relationships add the CiviCRM tables so you can show both Event & Membership data.
  Add the Drupal Views Data Export module so you can download the results and print it.
  
  > **Comments:**
  > **username_3**: There is also Views PDF  
  > **username_0**: Both of these require Drupal, which doesn't work as we are running Wordpress  
  
  ---
  
  ### Answer by username_2 on 2019-12-02. Score: 1
  
  Under Actions use the Export as CSV for the event and the members reports. Then copy and paste the one list with the other and sort them however you want. I know it is not one simple step within Civi but it should get you what you are looking for.
  
  > **Comments:**
  > **username_0**: Not really. I don't want a manual process, I want a report that a non-technical user can print for the meeting  
  
  ---
  
  ### Answer by username_4 on 2019-12-02. Score: 0
  
  I think that you can do this with the constituent detail report under contact reports.
  
  First of all, I think you need to create a temporary group with the people you are interested in. Find the participants for the event you want and add them to the temp group. Then find the contacts in the group you are are interested in and add them to the temp group.
  
  Then in the constituent detail report filter by the temp group. In the columns selection, remove all to do with contributions and activities, add email in for the contact and select other columns as you require.
  
  > **Comments:**
  > **username_0**: That doesn't really work either, as you don't end up with one person per row, with columns for Membership Type, Status, End Date  
  > **username_4**: In which case I don't think you will find what you want in an existing report and would have to write a new report.  
  > **username_0**: Ya. I find CiviReport to be quite clunky and not at all flexible, hence why I have both Extended Reports and Reports Plus enabled. Hopefully we will see a new structure come in the future that combines Search Builder-style functionality with the reports  
  > **username_2**: I hesitate to write this because you cannot hear the tone, but...   CiviCRM is Open Source. Extended Reports and Reports Plus exist because someone saw a need and ran a campaign to fund a fix. Also Civi in general needs regular funding to keep improving. You might have to work within the WordPress/Civi communities to have a fix made. Please understand, I know nothing about you so this is not directly pointed at you. For all I know, you are the top donor to Civi. But I just wanted to take the opportunity to put in a plug on behalf of those that have made all of this possible so far. THANKS!  
  
  ---
  
  