Running Total w/ Page Reset

[Bontebok]

Does anyone know how to create a running total that is reset at the start of the page?

Thanks,
Bontebok

 

[lbass]

Use the three-formula method:

Create a reset formula {@resetpagetot} and place it in the page header:

whileprintingrecords;
numbervar pagetot := 0;

Create a detail record formula {@detpagetot} and place in the details section:

Whileprintingrecords;
numbervar pagetot := pagetot + {table.yourfield};

Create a display formula {@displaypagetot} and place in the page footer:

whileprintingrecords;
numbervar pagetot;

-LB

 

[Bontebok]

Thanks!

Did the trick.

Bontebok