Clearing totals in a report

Totals reflect accumulations at selected attribute levels and can be applied dynamically to any report. These totals can also be cleared from a report. There are various totals available to you such as count, minimum, maximum, standard deviation, and so on.

The inclusion of subtotals, totals, and grand totals is not always necessary (or desirable) for report display. In addition, the columns or rows for which subtotal and total calculation is sought are not always the same ones. Whenever one of these conditions is present, it is advisable to clear the current display of totals. The procedure that follows describes how to clear totals in a report.

To clear totals in a report

1. Open the report in the Report Editor or Report Viewer.

   • How do I open the Report Editor?

   • How do I open the Report Viewer?

2. From the Data menu, select Subtotals.

3. Click Clear All. (This option is only enabled if there are subtotals on the report.)

4. The message "Are you sure you want to clear all subtotals?" is displayed. Click Yes to proceed.

5. Click OK to return to the report.