Include Subtotals and Grand Totals (New Layout/Report assistant)

In this panel of the New Layout/Report assistant, you can design a report with grouped data, which includes summary fields that total data by group (for example, total sales by region).

To include summary fields:

Choose Include subtotals or Include grand totals, or both.


If you create a subsummary report, you can’t choose to wrap fields to multiple lines. If you select more fields than will fit across the printed page, they extend beyond the page margin. Try either changing the page orientation to horizontal (landscape), reducing the print scale to less than 100%, or manually adjusting the fields in Layout mode.