Pro SQL Server 2012 Reporting Services

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

Figure 13-36. Setting up report filters

Now, when you preview the matrix report in Figure 13-37, you can see that the numbers have been

cleaned up and all empty fields are gone; also, you are prompted for the discharge year. Change the

Discharge Year parameter to 2011 to see those results. Save the report as Average Length of Stay to the

Pro_SSRS folder on the report server, just as you did the table report. We will now move on to create the

final report using Report Builder 1.0, the chart.