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

To add a subtotal to a banded list

1. In the Layout view of the report, drag a numeric field onto the detail band of the banded list. (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 banded list to the name of the dataset from which you dragged the field.
2. Add a grouping to the banded list.
   • Right-click the list 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 bands appears between the detail band and the header and footer bands.
     
3. Drag the same numeric field into the group footer band.
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 banded list

1. Drag the same numeric field used above into the footer band at the bottom of the banded 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 banded list.

See Also