Overview
The Select Report Type step of the Report Wizard allows us to choose from a Tabular or Matrix type of report. In this section, we will discuss the details of these available report types.
Explanation
The Select Report Type step in the Report Wizard will display the dialog as shown below:
The tabular report type is the traditional report with page headings, column headings, subtotals, and totals running down the page. The matrix report type is one where we define the fields that go on the columns and rows. In addition, the matrix report type provides interactive drilldown capabilities. We’ll create a tabular report, as this will provide a simple and familiar example.
Click Next to move on to the Design the Table 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)
