Running Page Total


Active Member

I have a problem with the page total. My report needs a page total to be at the bottom of a page. However, the total always total up the next record in the next page. FYI, I calculate the Page Total in the "Detail Section" assign the totals to the Page Footer.

I tried a suggestion posted here which is to subtract the last value form the total and add them up again for a new page total. THis is OK for a while but when the report reaches the last page, it will still subtract ths last value, hence making it incorrect. Any suggestions to this, anyone?


OneWorld XE, Intel Win2000 SP2, SQL 7 SP1