Counting in grouped reports

[MsT]

I have several reports which are grouped. I would like to count the grouped levels rather than the actual records.

So for example, one is a match report, with the players who played in each match, grouped by the matches. (Matches stored in one table, players in another linked as a one to many.) How do I count the number of matches, rather than the number of players? It doesn't make a difference where I put the count calculation, or what I count, it counts the number of records in the detail section, i.e the players

How do I go about counting the matches?

Cheers in advance

 

[Micron]

You'll need to put an invisible text box in the group header or footer whose source =1 and set it to Sum Over All; and a control in the report footer that sums the name of the invisible control just by referencing it (=[summingTextboxName)

 

[MsT]

Thank you so much - this is brilliant.

 

[Micron]

I take it that it worked, so you're welcome, and glad to help.