كريستال ريبورت, كيف يتم تجميع كل صفحة على حدى؟ هنا الحل

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!