Answers.Body: <p>Which report template are you using? </p>
  
  <p>I'm able to bring up a list like this using the Event Participant Report (list), just by sorting by Event and then name - by default it sorts by name first - and not using any grouping. </p>
  
  <p>It doesn't change the column layout - it still has the name first, but it is ordered by event first.</p>
  
  <p>(I have noticed some old saved reports failing after upgrades, but haven't had problems recreating them)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-18T13:55:38.513Z
Answers.Text: I've used Participant list Count Report because I'm not able to create a new report based on the Event Participant Report (List) template. I always get a blank screen because civicrm is trying to open a file in the directory /CRM/Report/Form/Event/ParticipantListing which doesn't exists. This file seems to be missing since my previous crm update (deleted the whole civicrm directory). I guess it was a custom template.
Answers.UserDisplayName: Philipp Michael
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-18T14:03:18.883Z
Answers.Text: I solved my template problem by searching the database for the class name "CRM_Report_Form_Event_ParticipantListing_NameOfTheMissingFile" and trimed it to "CRM_Report_Form_Event_ParticipantListing" (table civicrm_option_value). Now I'm able to access Event Participant Report (list) and can create a participant list of multiple events ordered by event name. Weird update hassle.
Answers.UserDisplayName: Philipp Michael
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-16T14:36:37.780Z
Answers.LastActivityDate: 2015-12-16T14:36:37.780Z
Answers.UserDisplayName: liblogger
Body: <p>I want to get a list of participants of multiple events ordered by event name (primary) and participant name (secondary) but I don't know how to accomplish this with CiviReport. The result should look like this: </p>
  
  <p><a href="https://i.sstatic.net/LvrXa.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/LvrXa.jpg" alt="enter image description here"></a></p>
  
  <p>I'm only able to sort by the participants name. And group by event name results a list of events, not participants.</p>
  
  <p>Currently I'm using CiviCRM version 4.6.10. In 4.3.4 it was possible to accomplish such a list but I'm not able to reuse those reports (blank screen on request).</p>
  
Tags: <civievent><civireport>
Title: How to get a participant list of multiple events ordered by event name
ThreadText: # How to get a participant list of multiple events ordered by event name
  
  (Asked by: username_0 on 2015-12-16)
  
  I want to get a list of participants of multiple events ordered by event name (primary) and participant name (secondary) but I don't know how to accomplish this with CiviReport. The result should look like this:
  
  [![enter image description here](https://i.sstatic.net/LvrXa.jpg)](https://i.sstatic.net/LvrXa.jpg)
  
  I'm only able to sort by the participants name. And group by event name results a list of events, not participants.
  
  Currently I'm using CiviCRM version 4.6.10. In 4.3.4 it was possible to accomplish such a list but I'm not able to reuse those reports (blank screen on request).
  
  **Tags:** civievent, civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-12-16. Score: 2 | Accepted answer
  
  Which report template are you using?
  
  I'm able to bring up a list like this using the Event Participant Report (list), just by sorting by Event and then name - by default it sorts by name first - and not using any grouping.
  
  It doesn't change the column layout - it still has the name first, but it is ordered by event first.
  
  (I have noticed some old saved reports failing after upgrades, but haven't had problems recreating them)
  
  > **Comments:**
  > **username_0**: I've used Participant list Count Report because I'm not able to create a new report based on the Event Participant Report (List) template. I always get a blank screen because civicrm is trying to open a file in the directory /CRM/Report/Form/Event/ParticipantListing which doesn't exists. This file seems to be missing since my previous crm update (deleted the whole civicrm directory). I guess it was a custom template.  
  > **username_0**: I solved my template problem by searching the database for the class name "CRM_Report_Form_Event_ParticipantListing_NameOfTheMissingFile" and trimed it to "CRM_Report_Form_Event_ParticipantListing" (table civicrm_option_value). Now I'm able to access Event Participant Report (list) and can create a participant list of multiple events ordered by event name. Weird update hassle.  
  
  ---
  
  