Create Running Total Field Dialog Box
Use this dialog box to create or edit running total fields. Running totals are totals that are displayed on a record by record basis. Running Totals total all records (in the report, in the group, and so on) up to and including the current record.
This dialog box appears when you right-click Running Total Fields in the Field Explorer and click New.
Note
This dialog box is the same as the Edit Running Total Field dialog box. This description applies to both dialog boxes.
| Available Tables and Fields | Lists all tables and fields in the report. Choose the field you want to summarize (the field on which a running total will be based) from this list. |
| Running Total Name | Type the name of your running total, for example Last Year's Sales, into the Running Total Name box. |
Summary
| Field to summarize | The Field to summarize list will display a field you select from the Available Tables and Fields list. The running total you are creating will be based on the field in the Field to summarize list.
Use the Add button (>) to copy a field from the Available Tables and Fields list to the Field to summarize list. |
| Type of summary | Use the Type of summary list to select from a number of summary options. The summary type you choose will determine the running total calculation.
Note Summary-type options change depending on the field you chose to summarize. |
Evaluate
| For each record | Use the For each record option to have your running total evaluate each record in a field. |
| On change of field | Use the On change of field option to have your running total perform its evaluation only when a specified field has changed.
Note Use the Add button (>) to copy a field from the Available Tables and Fields list to the On change of field list. |
| On change of group | Use the On change of group option to have your running total perform its evaluation only when a specified group has changed. |
| Use a formula | Select the Use a formula option to have your running total use a formula when performing its calculations. |
Reset
| Never | Use the Never option to lock your running total field. With the Never button selected, your running total will perform its calculations on that field throughout the entire report. |
| On change of field | Use the On change of field list to have your running total evaluate or reset when a designated field changes.
Note Use the Add button (>) to copy a field from the Available Tables and Fields list to the On change of field list. |
| On change of group | Use the On change of group list to have your running total evaluate or reset when a designated group changes. |
| Use a formula | Select the Use a formula option to have your running total use a formula to determine when to reset. |