Adding sub-group totals in report footers.

[macca_24]

I am trying to create this report which is grouped by "Que" and then within "Que" it is grouped by "Acct Type" (report is extracted from a Query and looks something like this as an example).

Toy Que
A 8

B 10

Food Que
A 15

B 30

where Toy que and Food Que belong to the main group and "A" and "B" belong to the sub -group within the main group. I would like to total the sub-group in the report footer section so that for the above example it shld be displayed as follows i the report section:

A 23

B 40
Could anyone tell me how this can be done? Thanks

 

[Pat Hartman]

You need to add a subreport to the report footer to create the recap.