Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

How to: Add or Remove Total Rows (Report Builder 1.0)

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

  1. In the report design, select the field value for which you do not want to display a total.

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

  1. In the report design, select the field value for which you want to display a total.

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

  1. In the report design, select the field values for which you do not want to display a total.

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

  1. In the report design, select the field value for which you want to display a total.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.