Column totals are included in the body of data in your report output. If you have grouped data, you can include totals with each grouping, but it isn’t necessary to have grouping in order to include column totals. You can configure them to be included at the top or at the bottom of the columns or groupings.
To add column totals to your report, click the Totals button in the report designer and go to the Column Totals tab of the dialog box. You can configure the following settings for column totals:
- Fields: You can add column totals to any fields that are included in the report.
- Function: Select one of the predefined functions from the list, or select Custom to create a custom expression to calculate a total. See Custom Totals.
- Display Totals: Specify whether the totals are included at the top or the bottom of your report data.
- Add Column Totals to grouped data: Select the checkbox to display totals with the grouping information.
- Show only totals: Select this option to generate a report output that contains only the totals. Individual records are hidden. The following screenshot shows an example of a report with this option enabled. The data is grouped by Department, so there is a total displayed for each department. Without the grouping, the report would contain only the top "Totals" line.
-