1

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 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.

1

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.

  • 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. – S Christopher Nov 16 '15 at 23:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.