CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Pulling Event Report
Pages: [1]

Author Topic: Pulling Event Report  (Read 1099 times)

denversportsguy

  • Guest
Pulling Event Report
March 03, 2009, 02:49:17 pm
We are using CiviEvent to register volunteers for a multi day conference.  Because of the complex nature of the event and a multitude of volunteer roles we had to create 130 different "events" in CiviEvent to cover all possible days, jobs, and shifts. 

They system is working great for registration, however I am finding it difficult to pull a report that gives me a summary of how many people have registered in each of the 130 events without pulling each event individually?  Is there a way I can do this enmass without doing 130 different times?  Also it would be great to be able to pull rosters for all events at once instead of individually. 

Anyone have suggestions out there?

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: Pulling Event Report
March 03, 2009, 03:29:23 pm
Off the top of my head, it seems like you can do a search within find participants just searching on status (all those registered). This will give you a list of all those registered regardless of event. If you want to narrow it down further, you can put in a date range or role.

that should work fine for your roster list as well.
hope this helps
tony
http://dharmatech.org
oss@dharmatech.org
801.541.8671

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Pulling Event Report
March 03, 2009, 03:33:59 pm

you might also want to consider using the custom search functionality to build cumulative reports for your needs. might be significanly faster and more tailored for the way u've set it up

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

denversportsguy

  • Guest
Re: Pulling Event Report
March 03, 2009, 03:37:24 pm
very helpful...thanks...another question...is there a way to pull a report that will give me the number of register participants vs the max number of participants for all of the events at once?   bascially I would like a report that would look similar to the event summary that is shown when you click on civievent.  that page only lists ten events.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Pulling Event Report
March 03, 2009, 04:12:40 pm

you will need to write a custom search for that one. You should be able to copy a fair amount of the code from:

CRM/Event/BAO/Event.php, function getEventSummary

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Pulling Event Report
March 03, 2009, 09:30:12 pm
Hi, The event aggregate search gives the number of participants in each event (but not the max).
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Pulling Event Report

This forum was archived on 2017-11-26.