Answers.Body: <p>Depending on your version of CiviCRM you can probably get what you need with SearchKit:</p>
  <ul>
  <li>search for events with event participants</li>
  <li>where event start date in 'this week'</li>
  <li>add columns to results to include event name, date, participant id (and any other column you may want/need)</li>
  <li>group by event id</li>
  <li>set field transformations to count on 'participant id'</li>
  </ul>
  <p><a href="https://i.sstatic.net/7EYZi.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/7EYZi.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-31T08:14:27.543Z
Answers.LastActivityDate: 2022-03-31T08:14:27.543Z
Answers.UserDisplayName: RebeccaTregenna
Body: <p>I am trying to run a report of all Events with a start date in the current week, which would show title, start date, and ideally number of participants registered.  The nearest I can get is the Income Count Summary Report, but this does not seem to pick up the number of participants, even though the field is selected in Columns.  Also, there appears to be no tab for sorting, so the events are sorted in a random order, when date order would be useful.  Is there another option I could try for this report?  Thank you in advance.</p>
  
Tags: <civireport>
Title: Events Summary Report
ThreadText: # Events Summary Report
  
  (Asked by: username_0 on 2022-03-30)
  
  I am trying to run a report of all Events with a start date in the current week, which would show title, start date, and ideally number of participants registered. The nearest I can get is the Income Count Summary Report, but this does not seem to pick up the number of participants, even though the field is selected in Columns. Also, there appears to be no tab for sorting, so the events are sorted in a random order, when date order would be useful. Is there another option I could try for this report? Thank you in advance.
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-03-31. Score: 4
  
  Depending on your version of CiviCRM you can probably get what you need with SearchKit:
  
  * search for events with event participants
  * where event start date in 'this week'
  * add columns to results to include event name, date, participant id (and any other column you may want/need)
  * group by event id
  * set field transformations to count on 'participant id'
  
  [![enter image description here](https://i.sstatic.net/7EYZi.png)](https://i.sstatic.net/7EYZi.png)
  
  
  ---
  
  