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.

Stepped
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.

Block
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.

Include subtotals
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.

Enable drilldown
Choose this option to hide the inner groups of the report, and enable a visibility toggle, resulting in a drilldown report.

Report Wizard Help

Community Additions

Show: