Count Gender by Event

[ktalley]

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

[mr_vodka]

You can add a new sub summary by event ID

[ktalley]

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?

[comment]

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.

[mr_vodka]

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, 2012 by mr_vodka
didnt see the post by comment

[ktalley]

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

[comment]

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.

[ktalley]

That did it. Thanks for your help!