Create a report using the
Customer and Orders tables from the Xtreme sample database.
Select the
CUSTOMER_NAME field from the Customer table, and the
Order
ID and
Order
Amount fields from the Orders table, and place them in the Body
section.
In the
"Field
Explorer" view, right-click
Running
Totals, and click
New.
Select the new running
total.
The running total settings are
displayed in the
"Properties" view.
In the
"Properties" view, in the
Name box, type the name "TotalOrders".
From the
Summarized
Field list, select {orders.ORDER AMOUNT}.
From the
Summary
Operation list, select
Sum.
From the
Evaluate
Condition Type list, select
On change of
field.
From the
Evaluate
Condition list, select Orders.Order ID.
The running total will execute each
time this field changes.
From the
Reset
Condition Type list, select Never.
Insert the running total
field in the Body section of the report, to the right of {orders.ORDER AMOUNT}.
On your report, each row in the
running total column displays the current record value added to the previous
values. This total continues, unbroken, through the report.