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) »
  • Actual number of participants report
Pages: [1]

Author Topic: Actual number of participants report  (Read 1552 times)

Arthurm99

  • I’m new here
  • *
  • Posts: 5
  • Karma: 1
  • CiviCRM version: 3.3.3
  • CMS version: Joomla 1.5.22
  • MySQL version: 5
  • PHP version: unknown
Actual number of participants report
July 25, 2011, 12:12:12 pm
Hi

Is there a simple report or MySQL query that lists all events with the actual number of participants registered.

I’ve have been having a look at the database structure it seems that the only place you can pick the actual participants is within the fee_level field in civicrm_participants but this is a text field and is very messy in stripping out the data if multiple price sets have been used. I hope I have missed something simple here, as on the find participants screen it counts the actual participants correctly in the criteria summary.

Many thanks 

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Actual number of participants report
July 25, 2011, 04:52:10 pm
I assume you're using the Participant Count feature in price sets (where a single participant registration can cover > 1 participant count) ??

Looks like the "Event Income Report (Summary)" does not handle the counts correctly in this scenario. I think your options are:

1. SQL query with SUM against the civicrm_line_item table (participant_count column in that table carries the count as an INT - and you can join entity_id to participant.id).

2. Extend the report above to handle line_item participant_count (which would be awesome). If you decide to do this please post back here w/ your code (or attach as a patch to an issue tracker issue).
Protect your investment in CiviCRM by  becoming a Member!

Arthurm99

  • I’m new here
  • *
  • Posts: 5
  • Karma: 1
  • CiviCRM version: 3.3.3
  • CMS version: Joomla 1.5.22
  • MySQL version: 5
  • PHP version: unknown
Re: Actual number of participants report
July 26, 2011, 07:47:10 am
Many thanks for pointing me in the right direction. I will have a play over the next few days and revert back.

GregoryHeller

  • I post occasionally
  • **
  • Posts: 73
  • Karma: 3
Re: Actual number of participants report
October 19, 2011, 02:58:59 pm
Dave, it looks like the Income Count Summary Report doesn't handle counts correctly at all. I just tested on the demo site and it is displaying 0 participants even though when you drill down into specific events you can see participants. it also doesn't seem to be reporting income properly, but that may be a result of having different currencies recorded, i'm not sure.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Actual number of participants report
October 20, 2011, 11:23:51 am
That report was contributed by a community member and I'm pretty sure it's designed for organizations whose events use price sets. I think it does handle counts correctly for that use case - including counts > 1 built into price set field options (e.g table for 8). The Event Income (Summary) handles non-price set events.

Would be good if both reports handled both use cases at some point but not sure if organizations often use both models ??
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Actual number of participants report

This forum was archived on 2017-11-26.