Pro SQL Server 2012 Reporting Services

CHAPTER 4  LAYING OUT A REPORT

Figure 4-20. Matrix data region

With the Matrix Start.rdl report open, double-click the Matrix object in the Toolbox, which will

automatically add a Matrix to the design area of the report. Next, drag two fields onto the Matrix,

Patient_Name and Estimated_Cost, from the emp_svc_cost dataset. They go in the Rows and Data areas,

respectively. For the Columns area, define an expression that concatenates the Service_Year and

Service_Month fields. Note that you may have to delete the header that was added automatically for the

Estimated Cost field. The expression is as follows:

=Fields!Year.Value & " - " & Fields!Month.Value