Pro SQL Server 2012 Reporting Services

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

Figure 13-40. Adding the Active Patients filter

Next, drag the Branch Name field to the Categories area of the chart. You could add further series

items or categories to the chart, but to keep the chart simple and to address the request, you will just

apply some formatting to the chart by way of removing the chart title so that it does not say “Chart Title”

on the report. To modify the chart properties, follow these four steps:

1. Right-click the chart, and select Chart Options.


2. On the Titles tab, delete the text for the chart, Category X and ValueY titles.


3. On the Legend tab, remove the check from the Show legend checkbox.


4. Finally, on the 3D tab, check the Display Chart with 3-D Visual Effect box, set
   Horizontal Rotation to 25, set Vertical Rotation to 10, Realistic as the Shading,
   and select Cylinder as the shape, as shown in Figure 13-41.