Help!! Printing Group summary in Report Footer

[jen1701]

I have gouped summary which I would like to print them in the report footer section. So the user can go to the end of the report to view the summary on the group and the total report summary. for example:
The report is grouped on location. So the following infor is on the group footer.
Locatiion 1: 5
Locatiion 2: 7
Locatiion 3: 8
Locatiion 4: 9

I want to report the above summary in the report footer. So in the report footer it would be:

Location summary:
Locatiion 1: 5
Locatiion 2: 7
Locatiion 3: 8
Locatiion 4: 9
Total Summary: 29

Any suggestions how to do this? Thank you very much in advance.

Jen

 

[glalsop]

You could insert an unlinked subreport in the report footer that has the same record source as the main report, but only displays summaries for all of the groups.

-Gary

 

[jen1701]

Thanks Gary. I will try your suggestion.

Jen