Add a total in the Report Footer section

1. On the menu bar click Toolbox, then click Add Data Field.
2. Click once in the Report Footer section where you want the total to appear.
3. In the Add Data Field window, expand the relevant table, for example, SALES_LEDGER.
4. Click the required data field, for example, BALANCE, then click OK.
5. If the Active Complete window appears, click Cancel.
6. Click the data field you added, then in the Properties pane, in the Function drop-down ensure this is set to Sum.
   
   
   
   
   

Add a total in a group footer section

To add a subtotal to a report, the process is the same as adding a total, but you add the data field to the relevant group footer instead of the report footer

1. On the menu bar click Toolbox, then click Add Data Field.
2. Click once in the group footer area where you want the total to appear.
3. In the Add Data Field window, expand the relevant table, for example, SALES_LEDGER.
4. Click the required data field, for example, BALANCE, then click OK.
5. If the Active Complete window appears, click Cancel.
6. Click the data field you added, then in the Properties pane, in the Function drop-down ensure this is set to Sum.
   
   
   
   
   

Add a running total

You can add a running total to your document by adding the required data field into the Details section of the report, and setting the Function to Sum.

1. On the menu bar click Toolbox, then click Add Data Field.
2. Click once in the Details section where you want the running total to appear.
3. In the Add Data Field window, expand the relevant table, for example, SALES_LEDGER.
4. Click the required data field, for example, BALANCE, then click OK.
5. If the Active Complete window appears, click Cancel.
6. Click the data field you added, then in the Properties pane, in the Function drop-down click Sum.
7. In the Properties pane, in the Reset Section drop-down click the required option as follows:
   

   To create a running balance for each account	Click the relevant group footer, for example, ACCOUNT_REF Footer.
   To create a running balance for the whole report	Click None.