I'm using the Invisible text box set to =1 in the Detail and Grouping headers to get overall counts for my report. These calculate accurately if the Total textbox is put in the report footer. Can the same be done in the report header? By the way, I am using filters on these reports, so it becomes necessary to do calculations after the filter has been applied on the report, rather than using another query to calculate totals and reporting them.

Is there a way to do this using subreports?