Author Topic: How do I display the number of “Total Participants”? (Read 1566 times)

ajjumba · May 18, 2011, 10:10:36 pm

I am working with the ‘Participant list Count Report’ template and I would like to show the count of individual participants (what I believe to be Total Participants). Right now all I get is the total number of rows yet I would also like to show the total number of individual participants because I have some participants registered in two or more events but I would like to count them only once.

Any help or ideas would be most appreciated.

Many thanks.

ajjumba · June 25, 2011, 11:44:56 pm

Is there anyone out there who could help me?

I would really like to get a count of the distinct participants in events. For example when you have two events and you have a participant listed in both but you only want to count him once.

I could really use some help on this one if anybody has any ideas.

xavier · June 26, 2011, 01:57:54 am

You will need to write a custom report, with a select distinct from civicrm_participants.

http://en.flossmanuals.net/civicrm/ch064_reports/

Write it as extensions, will be easier to install and share if you want to.

X+

ajjumba · June 26, 2011, 10:09:53 am

thanks xavier. I'll give it a shot and see.

CiviCRM Community Forums (archive)

News:

Author Topic: How do I display the number of “Total Participants”? (Read 1566 times)

ajjumba

How do I display the number of “Total Participants”?

ajjumba

Re: How do I display the number of “Total Participants”?

xavier

Re: How do I display the number of “Total Participants”?

ajjumba

Re: How do I display the number of “Total Participants”?