Totals per page in Crystal

[dandman71]

I am creating a report to count employyes based off the empno filed in a VFB database. NO grouping, just the names of the employees nad some personal information, generally 2 to 5 lines worth. All records are on the detail line and one GF to pull in the history records I am requesting.

My issue is this. I need to create a total that is based on the 'page', not a group. Is there a formula that I can use to create this? Thank you

 

[mbarron]

You can do this using a 3 formula running total.

In the page header (field is suppresed):
whileprintingrecords;
numbervar collect:=0

In the band where the data is located (fields also suppressed):
whileprintingrecords;
numbervar collect:=collect + {data.field}

In the page footer:
whileprintingrecords;
numbervar collect

Mike