Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-32. Blank matrix report

To start this report, expand the Total Length of Stay attribute in our Fields list. Drag the Avg Length

of Stay attribute that was calculated when the model was generated over to the totals area of the Matrix.

For the row grouping, add the Discharge Reason field. Finally, drag the Marital Status ID field to the

column grouping area so that the matrix report resembles Figure 13-33. It will be necessary to resize the

Discharge Reason field and center-justify the Marital Status ID field. You will also at this time add a title

to the report: Average Length of Stay. Make the title bold and set the font type to Arial Rounded MT Bold.