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, select the {CUSTOMER.CUSTOMER_NAME} field,
right-click, and click
Group on
Field.
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 "GroupRunningTotal".
From the
Summarized
Field list, select {orders.ORDER AMOUNT}.
From the
Summary
Operation list, select
Sum.
From the
EvaluateCondition
Type list, click
For Each
Record.
From the
ResetCondition
Type list, click
On Change of
Group and accept the default group name.
Place the running total
field in the Body section of your report to the right of the {orders.ORDER
AMOUNT} field.
Note: If you want to view
a grand total of each group, place the running total field in the Group Footer
section of your report.