To add a grand total to the report footer

1.  Add a field to the report footer. See To insert a group header for more information.

89_image68.png

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 <Enter>.

89_image69.png

6.  The words = Grand Total appear in the frame and the grand total for the group appears on the last page of the report.