If you have suppressed data, or your data is based on a formula that occurs WhilePrintingRecords, you should create a running total formula rather than using the Running Total Select Expert.
When you create a running total manually, you need to create three formulas:
In the following procedure, you will create a report that performs the following functions:
Select Formula Fields in the Field Explorer dialog box and click New.
Amount := Amount + {orders.ORDER AMOUNT};
Click Save and Close.
This formula prints the running total of the values in the Order Amount field.
On the Insert menu, click Group and group the report on the {customer.CUSTOMER NAME} field.
Set the value in the Amount variable to 0.
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.
This formula simply displays the current value of the Amount variable at any time.
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.
Note: This formula prints the same value that @RunningTotal prints as the running total for the last record in each group. But since it is printing it in the Group Footer section, it acts as a group subtotal, not as a running total.
| Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |