Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-37. Setting up report filters previewing the report


Creating a Chart Report

The last report type available in Report Builder 1.0 is the chart report. Thus far, you have created and
saved table and matrix reports to address many of the report requests for the Patient Census report.
Now, we will show one of the most important reports to answer the question of the number of patients
on the census. Census means that the patients are currently receiving services and have not been
discharged. In the database you are using, a patient is considered active if his or her discharge date is
Null, or, in Report Builder 1.0 vernacular, empty. The chart you create will be a simple bar chart showing
a count of active patients by their branch association.
Return to the design area of Report Builder 1.0, and click the chart report in the Report Layout tab.
The blank report template has a single Chart data region, as shown in Figure 13-38. As you did with the
two previous reports, table and matrix, you will add a title: Active Patient Census.

Free download pdf