Choose the Table Layout
Applies To: SQL Server 2016
Use this page of the Report Wizard to select the layout of the table in the report.
Create a report that contains one column for each field, with group fields appearing in group headers to the left of the detail field columns. This type of table does not have group footers.
Create a report that contains one column for each field, with group fields appearing in the first detail row for each group. This type of table has group footers only if Include subtotals is also selected.
Choose this option to include a subtotal for the numeric fields in the report. If Stepped is selected, the subtotal is placed in the group header rows. If Block is selected, the subtotal appears in the group footer rows.
Choose this option to hide the inner groups of the report, and enable a visibility toggle, resulting in a drilldown report.