Hello, I calculated subtotals of each group in the group footer. Instead of present the subtotals at the end of each group, I want to present all subtotals together at the end of the report. Could anyone give me a hand? Thank you very much.

The report will look like this:

Group A
Detail ...
Group B
Detail ...

Subtotals: Group A 80
Group B 30

in the report header you should be able to add a textbox =sum([GroupA]) and another textbox =sum([GroupB])

sam

Hi, Sam, thank you for your reply. But that is not what I want. Maybe I simplified my question.

I have three groups: by Country, by Region and by project Status.
It looks like this:
Country: USA
Region: New York
Project: Active
Project 1 ..
project 2 ..
Project: Completed
Project 3 ..
....
Region: Boston
...

Within each country, I want to present the subtotals for regions together right before teh grand total for each country.

Could you pelase give me more help? I calculated subtotals in Region footer. Thank you.

i don't think i understand exactly what you want to do. i will tell this, if you want you can create subFooters. basically go to top (toolbar) and find the icon for Sorting/Grouping and you can have many groups. if you would like a total after a group then on the Sorting/Grouping screen you select the group and on the bottom you select 'yes' for group footer.

good luck,

sam

Sam. I paste a pic. to show what I try to do. Basically, I want to show subtotals of each region group together before start a new Country section.

Thanks for your kind help.

sorry, but i was having problems with this one as well. i have a posting where i state that i have problems with this.

sam