# Thread: How to calculate an overall total for each report page and final total?

1. Registered User
Join Date
Apr 2004
Posts
77

## Unanswered: How to calculate an overall total for each report page and final total?

Hi there

I want to be able to generate an over all total for each page of my report and then a final total for the over all report.

For the overall total for the page, I have tried using the running sum and I noticed that this carries the total for each line over and so on.

Is there a way to just create an overall total at the end of each report page and then to generate a final total for the whole report?

Any suggestions pls.

Many Thanks for ur help in advance.

2. Registered User
Join Date
Oct 2003
Location
Ger
Posts
1,969
Try to make instead of page sum Groupe Sum. Then make another text box to sum this Groupe's sum to get the total sum.

3. Registered User
Join Date
Apr 2004
Posts
77

## re how to calculate report total on page

Hi hammbakka

Many Thanks for ur replies to my messages . Much appreciated.

sorry what did u mean by groupe ?

is this what u mean instaed of = sum(amountinpounds) this
=groupe(amountinpounds)?

Many Thanks for ur help.

4. Registered User
Join Date
Oct 2003
Location
Ger
Posts
1,969
No, what I meant is make a new Group in the Report (a part as your Details one)
then put a text box there, set its value to =1, and adjust its to property to be sum over all or sum over the group.

5. Registered User
Join Date
Jan 2004
Location
Posts
97
Sum your fields in Page footer and Report Footer to get the page totals and the final report totals

- Saqib

6. Registered User
Join Date
Apr 2004
Posts
77