Operation Manual

Running Totals
Creating running totals using a formula
11
Crystal Reports User’s Guide 211
5. Enter the following into the Formula box:
WhilePrintingRecords;
CurrencyVar Amount;
Amount := Amount + {orders.ORDER AMOUNT};
6. Click the Save and close button on the Formula Workshop.
7. Place this formula in the Details section of your report, just to the right of
the {orders.ORDER AMOUNT} field.
This formula prints the running total of the values in the Order Amount field.
8. On the Insert menu, click Group and group the report on the
{customer.CUSTOMER NAME} field.
9. In the Formula Workshop, create “AmountReset”:
WhilePrintingRecords;
CurrencyVar Amount := 0;
This formula says:
Set the value in the Amount variable to 0.
10. Place this formula in the Group Header #1 section of your report.
Because the Group Header #1 section appears once for every group,
@AmountReset will execute each time the group changes. Thus, the
Amount variable is reset to 0 each time a new group begins.
11. Select the @AmountReset formula on the report and use the Format
Editor to suppress it so that it will not appear in the final print-out.
12. In the Formula Workshop, create “AmountDisplay”:
WhilePrintingRecords;
CurrencyVar Amount;
This formula simply displays the current value of the Amount variable at
any time.
13. Place this formula in the Group Footer #1 section of your report.
Because the Group Footer #1 section appears once for every group,
@AmountDisplay will execute each time a group ends. Thus, the value
stored in the Amount variable will be printed each time the group changes.