How to create a page total

Creating a Page Total in Crystal

It is strange that a powerful program like Crystal does not have a simple way to calculate a page total. Here is the best way we have found.

Step One: Create a formula field called reset with the following expression:

//reset
WhilePrintingRecords;
shared numbervar total := 0

You can use any name to substitute for the word ætotalÆ.

Step Two: Create a formula field called accum with the following expression:

//accum
WhilePrintingRecords;
shared numbervar total := total + {table.numberfield};

Step Three: Create a formula field call display with the following expression:

//display
WhilePrintingRecords;
Shared numbervar total;
Total

Place the formula field reset in the page header. Right-click on it, pick ôformatö and then pick the common tab. Pick ôsuppressö.

Place the formula field accum in the details section. Right-click on it, pick ôformatö and then pick the common tab. Pick ôsuppressö.

Place the formula field display in the page footer. Position and format it as required.

That is it!