Overview
The Choose Table Layout step of the Report Wizard allows us to choose a stepped or blocked layout and whether to include subtotals and enable drilldown.
Explanation
The Choose Table Layout step in the Report Wizard will display the dialog as shown below:
The default of Stepped displays the groupings as shown above. Block moves things in a little closer, which saves space, but it disables drilldown. Include Subtotals will provide intermediate totals based on groupings. Enable drilldown will initially hide details and allow expanding with a click on the plus icon.
Fill in the dialog as shown below:
Click the Next button to move on to the Choose the Table Style dialog, which we will discuss in the next section.
Ray is a Principal Architect at IT Resource Partners focused on SQL Server and Business Intelligence. He is a Microsoft Certified Solutions Expert (MCSE) in Business Intelligence, a MSSQLTips.com BI Expert and Ambassador. He is also a co-author of the book: SharePoint 2010 Business Intelligence Unleashed.
- MSSQLTips Awards: Champion (100+ tips)
