HP Intelligent Management Center Standard Software Platform User Manual

Page 270

Advertising
background image

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.

270

Crystal Reports 2008 SP3 User's Guide

Running Totals

11

Creating running totals using a formula

Advertising