• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Running Page Total

samlsc

Active Member
Guys,

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?

Thanks!

Sam
OneWorld XE, Intel Win2000 SP2, SQL 7 SP1
 
Top