Sunday, 30 October 2011

Working with Data Bars

Data bars are use to make "Tornado charts" in order to get an idea as how values are distributed.
We will use the same data source tbl_Players for this demonstration too.
Objective
In this experiment, we will see how the players runs are distributed using Data Bar.
DataBar into action
In the design view, add a table with three columns. In the first column, let us add [Player Name] field while in the last two column let us add the [Runs Made] column. Let us rename the header of the third column to [Runs Analysis]
37.jpg
From the Report Item toolbox, let us drag and drop a Data Bar control on to the third column. The Data Bar Type properties window appears. From there let us choose the "Stacked bar" Data Bar type
38.jpg
And click OK. Right click on the Data Bar and from the context menu, choose Chart Properties
39.jpg
In the General section of the Chart Properties window, choose Gray Scale from the Color Pallet drop down.
40.jpg
And in the Fill section, choose Gradient in the Fill Style and provide some suitable gradients
41.jpg
Click OK and view the report
42.jpg
We can reverse the direction of the Data Bars. Right click on the Data Bar and from the context menu,choose Horizontal Axis Properties.From the properties dialog check the Reverse Direction checkbox of the Scale options.
43.jpg
The report is as under
44.jpg

No comments:

Post a Comment

SSIS: Creating Package Configurations

This post discusses the creation of Configuration Files and how they can be useful while migrating a package from one environment to an...