Working with Totals (Report Builder 1.0)

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.

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.