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
Formulas, and click
New.
In the
"Properties" view, in the
Name box, type "RunningTotal".
In the
"Field
Explorer" view, double-click
RunningTotal.
The Record Filter on the Formulas tab
appears.
On the Formulas tab, under
RunningTotal,
type the following formula:
WhilePrintingRecords;
CurrencyVar Amount;
Amount := Amount + {orders.ORDER
AMOUNT};
This formula prints the running total
of the values in the Order Amount field.
Save the report.
Place this formula in the
Body section of your report to the right of the {orders.ORDER AMOUNT} field.