Answers.Body: <p>Yeah, it's pretty silly that event start date isn't available as a header.  It's actually a really small change in the code, but it does require editing the code to add the field as an sorting option.</p>
  
  <p>I made a change that will hopefully be included in the next 4.6 release, but you can add it by editing the appropriate file.  In your CiviCRM codebase (found at sites/all/modules/civicrm in Drupal, administrator/components/com_civicrm/civicrm in Joomla, or wp-content/plugins/civicrm/civicrm in WordPress), edit the file at <code>CRM/Report/Form/Event/ParticipantListing.php</code> to apply the changes you see here: <a href="https://github.com/civicrm/civicrm-core/pull/7221/files" rel="nofollow">https://github.com/civicrm/civicrm-core/pull/7221/files</a> after line 299.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-16T23:37:54.943Z
Answers.Text: Fantastic! I was fumbling with the other explanation; so close but just couldn't make it work. This is exactly what I need. Thank you.
Answers.UserDisplayName: S Christopher
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-11-16T19:33:49.153Z
Answers.LastActivityDate: 2015-11-16T19:33:49.153Z
Answers.UserDisplayName: Andie Hunt
Body: <p>I am trying to create a report that lists the participants for upcoming events (each day for the next 14 days), sorted by event start date as the section header. Event Start Date is not listed in the Column dropdown.</p>
  
  <p>Event Start Date 
  -Event type
  --Participant Name 1
  --Participant Name 2</p>
  
  <p>Next Day Start Date
  -Event type
  --Participant Name 1
  --Participant Name 3</p>
  
  <p>I saw <a href="https://civicrm.stackexchange.com/questions/6897/event-report-template-adding-sorting-by-group">this</a> thread that gives me hope, but it doesn't specifically say how it was fixed. I've scoured the web trying to find a solution, but have come up with nothing else. </p>
  
Tags: <civireport><joomla>
Title: CiviReport Participant Sort by Event Start Date
ThreadText: # CiviReport Participant Sort by Event Start Date
  
  (Asked by: username_0 on 2015-11-16)
  
  I am trying to create a report that lists the participants for upcoming events (each day for the next 14 days), sorted by event start date as the section header. Event Start Date is not listed in the Column dropdown.
  
  Event Start Date
  -Event type
  --Participant Name 1
  --Participant Name 2
  
  Next Day Start Date
  -Event type
  --Participant Name 1
  --Participant Name 3
  
  I saw [this](https://civicrm.stackexchange.com/questions/6897/event-report-template-adding-sorting-by-group) thread that gives me hope, but it doesn't specifically say how it was fixed. I've scoured the web trying to find a solution, but have come up with nothing else.
  
  **Tags:** civireport, joomla
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-11-16. Score: 1 | Accepted answer
  
  Yeah, it's pretty silly that event start date isn't available as a header. It's actually a really small change in the code, but it does require editing the code to add the field as an sorting option.
  
  I made a change that will hopefully be included in the next 4.6 release, but you can add it by editing the appropriate file. In your CiviCRM codebase (found at sites/all/modules/civicrm in Drupal, administrator/components/com\_civicrm/civicrm in Joomla, or wp-content/plugins/civicrm/civicrm in WordPress), edit the file at `CRM/Report/Form/Event/ParticipantListing.php` to apply the changes you see here: <https://github.com/civicrm/civicrm-core/pull/7221/files> after line 299.
  
  > **Comments:**
  > **username_0**: Fantastic! I was fumbling with the other explanation; so close but just couldn't make it work. This is exactly what I need. Thank you.  
  
  ---
  
  