Display a group count in the page header.

[khughes46]

I seem to remember being able to reference a count to display in another section (the report header in this case), but can't seem to get it to work. Can somebody tell me how to reference a sub header count to display in the page header? Or let me know if it's not possible.

[June7]

Aggregate calc should work in report or group header/footer. Doesn't seem to work in page header/footer.

[ranman256]

Cant you put the page count at the footer, and let them look at the last page?

[khughes46]

Unfortunately no. The report is a roll sheet for different classrooms and periods. Each one must have a student count.

[ranman256]

You cant. The group count isnt calculated until the end of the rpt group.
You could put a DCOUNT("*",table,where) in the Report header .

[khughes46]

DCOUNT shows the total number of students for all Rooms/Periods. I need the count to be by Room/Period.