Summary per page

[UnleashThePain]

Hi I am having problems with running a summary on a report. The summary keeps adding the total per report upon each other, while I want the summary per page.

 

[dgillz]

Do you have a reset formula in the page header?

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

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[UnleashThePain]

I only have the options:
free form placement x
hide
supress x
print at bottom
new page after
reset page number after
keep together x
suppress blank section
underlay following sections


Fornicate Under Command of the King

 

[Madawc]

If you want to sum the values in variables for each page, do something like this:

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). Using Windows XP & Crystal 10

 

[lbass]

In Madawc's second formula, replace the 1 with the field you want to sum--assuming you are summing an amount field.

-LB