Use subtotaling in table groups to add meaning to your data. You can add subtotals using group header and footer rows, and grand totals using table header and footer rows.

To add a subtotal to a table group

1. In the Layout view of the report, drag a numeric field into the detail row of the table. (i.e. =Fields!SalesAmount.Value) This field repeats for each row of data in the associated dataset. This action also sets the DataSetName property of the table to the name of the dataset from which you dragged the field.
2. Add a grouping to the table.
   • Click inside the table to reveal the row and column handles along the left and top edges of the table.
   • Right-click in the row handles along the left edge of the table and select Insert Group.
   • On the Groups smart panel that appears, select a Group on expression by which to group the data. (i.e. =Fields!Store.Value)
   • Click the Accept button in the lower right corner to close the smart panel and apply the change. A new pair of rows appears between the detail row and the header and footer rows.
     
3. Drag the same numeric field into the group footer row.
4. The expression in the resulting textbox automatically uses the Sum function. This field repeats for each group (i.e. Store) in the data and displays a subtotal for that group.

To add a grand total to a table

1. Drag the same numeric field used above into the footer row at the bottom of the table.
2. The expression in the resulting textbox automatically uses the Sum function.
3. Preview the report to see that the new textbox supplies a grand total for the table.

See Also