Working with Totals (Report Builder)
New: 17 July 2006
Total and Grand Total rows are automatically added to Report Builder matrix or tabular reports that contain total fields. Total rows calculate the subtotals for each total field within a given group. The Grand Total row, which appears at the end of the entire report, calculates the grand total for each total field. For example, suppose you have a report that is grouped by Territory, and then Customer. The following fields are displayed in the report: Territory, Account Number, Customer Name, Sales Orders, and Totals Sales. By default, a Total row is added for the Customer group within each Territory and a Grand Total row for all territories within the report as shown in the following image.
.gif "Report with Customer and Territory subtotals.")
You can hide or show Totals for individual columns and for entire groups within your reports by selecting the total field in the report layout and then using the context menu or by selecting options from the Edit menu.
See Also
Tasks
How to: Add or Remove Total Rows (Report Builder)
Concepts
Working with Data (Report Builder)
Working with Report Layouts (Report Builder)