Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 4: A Visit to Emerald City: The Report Wizard > Creating Matrix Reports
Creating Matrix Reports
You have now seen much of what the Report Wizard can do for you when it comes to tabular reports. Now, let’s look at another report type the Report Wizard can produce for you. Prepare yourself. You are going to enter the matrix.
What Reporting Services calls a matrix report is referred to as a crosstab or a pivot table report elsewhere. In a tabular report, you have columns from a result set across the top and rows from a result set going down the page. In a matrix report, you have row values going across the top and down the page. Matrix reports are much easier to grasp once you have seen one in action, so let’s give it a try.
The Invoice-Batch Number Report
Feature Highlighted