Simple Page Total question

[JessB]

Hi, I have an invoice that I've created, but they want a total dollar amount for each page to be printed at the bottom of each page.
All that I really know how to do is to use the Running Total field, but I need it to reset after each page, and I don't know how to do that.
I have tried some different ways of working the page number into a formula and reseting the running total on the change of that formula, but it says the following error: "A running total cannot refer to a print time formula."

Can someone help me out and explain (in the simplest terms possible!) how to accomplish this?

I am using Crystal Reports X.

Thanks!
Jess

[jggtz]

Your formulas should look like:

This formula is in the page header:
@reset:

whileprintingrecords;
numbervar x;
x:=0


This formula is suppressed and is in the detail section:
@sum:

whileprintingrecords;
numbervar x;
x:=x+{table.field}


This formula is in the page footer:
@display

whileprintingrecords;
numbervar x


Now for each page it should display the sum displayed on each page.

[JessB]

JGGTZ:

Wow, thank you SO much for that explanation.
It was incredibly clear and was EXACTLY what I needed.
Again, thank you very much!

Jess