Pro SQL Server 2012 Reporting Services

CHAPTER 6  BUILDING REPORTS

Figure 6-33. Filter dialog box to exclude non-visits

The completed report with a filter applied to a Tablix data region in the Pro_SSRS project is called
EmployeeServiceCost_MVP_Filter.rdl.

Adding a Chart

SSRS provides a Chart data region that has a style similar to Microsoft Excel. Charts can be scoped within
the current dataset or can use their own dataset. For this example, you will add a stacked bar chart to the
beginning of the report that will show the top ten diagnoses and a count of the number of services for
each diagnosis. This will essentially mirror the data provided in the report thus far. This report is now
also grouped by Branch, which will automatically separate the values in the Branch group you have
defined. You will want to emulate this for your chart. You have only three branches in this particular