Adding a Grand Total to the Report Footer
To add a grand total:
1. Add a field to the report footer. See Inserting a Group Header for more information.
2. Select a field to total from the DataField property list box.
3. Select a summary function from the SummaryFunc property list box.
4. Select SummaryType in the Properties list box.
5. Click the drop down button. Choose 1 - ddSMGrandTotal from the list, and then press the Enter key.
The words = Grand Total appear in the frame and the grand total for the group appears on the last page of the report.