CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-31. Saving a report to the server
Creating a Matrix Report
Unlike a table report, a matrix report displays aggregated values two-dimensionally with column groups
as well as row groups. The totals, whether they are sums, averages, or counts, intersect at the grouping
levels for columns and rows. This creates a cross-tab report similar to a pivot table in Microsoft Excel.
One of the requests for the report was to show the length of stay for patients, from the time they were
admitted to the time they were discharged. It is also a requirement that the discharge reason show on
the report. You can combine these two requests perfectly into a single matrix report.
So, return to the Report Builder 1.0 design area, and click the Matrix (cross-tab) report in the Report
layout section of the Task Pane. This opens a new blank matrix template where you can drag and drop
fields onto the Matrix data region, just as you did with the table report. The template is nothing more
than a predefined Matrix data region to which you will add several fields, as shown in Figure 13-32.