Hello,

I am wanting to count the number of male and female participants in a particular event and display that number breakdown for all events. Here are the relevant tables:

Students -< StudentEvents >- Events

I have created a report that shows correctly the number of male and female per event. The layout I have in the Students Table is:

Body: EventID (using a pop-up menu to display the real name of the event)

Sub summary: Gender and Gender_Count (just a count of Gender)

Trailing Grand Summary: Gender_Count

When I do a find for a particular event and then sort by Gender it works great - but for one event at a time. Is there anyway that I can display on one report the breakdown of Gender and total for each event?

Thanks for your assistance

kt

You can add a new sub summary by event ID

Thanks for your reply. I had tried that, but was getting numbers that didn't add up. Then I tried using the EventID from the Events table and not the EventID from the StudentEvents table and it's closer, but there is still a problem.

Edit:

When I have a student who is attending more than one event, it only counts their gender in once for all the totals and not for each event they are in. If a student is in Event A and B it only count them in event A and not in Event B.

Any thoughts on that?

I am wanting to count the number of male and female participants in a particular event

To do this, your report must be produced from the StudentEvents table. Sort the records by EventID (or by Events::EventName) and by Students::Gender, and use corresponding sub-summary parts to show the sub-counts.

If you want to show the M/F breakdown for each event AND as a grand total, it's going to be more complicated.

Sorry I should have caught this sooner.

Your report should be based off the StudentEvents table not the Students table.

Group and subsummarize by eventID and gender. There should be a summary field in the StudentEvents table that counts the records.

Edit: Didnt see the post by comment.

Edited May 25, 201213 yr by mr_vodka
didnt see the post by comment

Thank you gentlemen. Having the layout in the StudentEvents table was what I was missing.

It would be nice to have the total number of participants per event on the same report - even though it's not hard to add two numbers in my head. How complicated are we talking?

Thanks

After finding the records you want to include in the report, sort them by gender and write the sub-totals to global fields/variables. Then proceed to sort as stated above and show the globals in the grand summary part.

That did it. Thanks for your help!