How to: Add or Remove Total Rows (Report Builder)
New: 17 July 2006
Total and Grand Total rows are automatically added to reports containing total fields. By default, they appear in the report and are calculated when the report is run. You can remove these rows from your report, and then add them back into the report later.
To remove Totals for an individual field
In the report design, select the field value for which you do not want to display a total.
On the Edit menu, click Show Subtotal.
The subtotal for that field is removed from the report design.
Note Alternatively, you can right-click the field values, and then select Show Subtotal.
To add Totals for an individual field
In the report design, select the field value for which you want to display a total.
On the Edit menu, click Show Subtotal.
The subtotal for that field is added to the report design.
Note Alternatively, you can right-click the field values, and then select Show Subtotal.
To remove group Total rows
In the report design, select the field values for which you do not want to display a total.
On the Edit menu, click Show Group Subtotals.
The totals for that group are removed from the report design.
Note Alternatively, you can right-click the field values, and then select Show Group Subtotals.
To add group Total rows
In the report design, select the field value for which you want to display a total.
On the Edit menu, click Show Group Subtotals.
The totals for that group are added to the report design.
Note Alternatively, you can right-click the field values, and then select Show Group Subtotals.
See Also
Concepts
Working with Total Rows
Report Builder How-to Topics