Use subtotaling in lists to add meaning to your data. You can add subtotals using detail grouping, and grand totals for a list can be easily added to the body of the report just below the list.

To add a subtotal to a list

1. In the Layout view of the report, drag a numeric field onto a list. With no changes, this field would repeat for each row of data in the associated dataset.
2. Change the expression in the value of the resulting textbox to use the Sum function to calculate the total. (i.e. change =Fields!SalesAmount.Value to read =Sum(Fields!SalesAmount.Value).)

   Note: If you preview the report at this point, you will notice that the summary field renders the grand total for the dataset after each sales amount, which is probably not the behavior we want.

3. Add a detail grouping to the list.
   • Right-click the list and select Properties.
   • On the Detail Grouping page, 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.
     
4. Now when you preview the report, a subtotal of the sales amount for each store is shown.

To add a grand total to a list

1. Drag the same field that shows subtotals in your list onto the body of the report just below the list.
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 list.

See Also