How to reset running totals on every page 1

[ipm]

I'd like to have a running totals field in my report and I'd like to reset this field on every page.

Does anybody know how to do this?

 

[dgillz]

Are you talking about a running total field that you get by clicking on insert, field object, running total field? Or are you talking about the variable approach with formulas?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

I don't think it is possible with running totals, which do not take notice of page changes.

You can do it with variables:

Place V_head in the Page Header section and suppress it

//   Clear the total
WhilePrintingRecords;
NumberVar PageTot :=0;

Place V_Item in the whichever section contains the field you want to total

// Accumulate
WhilePrintingRecords;
NumberVar PageTot := PageTot + 1;

Place V_Show in the page footer section

// Show
WhilePrintingRecords;
NumberVar PageTot;

Madawc Williams (East Anglia, UK)

 

[ipm]

I was talking about first option.