SSRS Reports can be used to Create “Data Bars”. Data Bars are used to make “Tornado charts” which represent Graphical Bars along with SSRS Reports to show how values are distributed.
Step-1: Create a SSRS Report Server Project with name “BasicSSRSChapter12” and create a new tabular report with the following query.
select ProductID,ProductName,QuantityPerUnit,UnitsInStock from Products
using “NorthwindDataSource” (Create Shared Data Source with SQL Server Northwind Database ) as shown in the image. Add one, more column to right side of report and choose “UnitInStock” Item again by right click on fifth column as shown in the image.
Rename the Label of fifth column to “Data Bar(Stock Position)”. Now from the Report Item toolbox and drag and drop a Data Bar control on to the Fifth column as shown in image.
Please choose the “Stacked bar” Data Bar type as shown in the image as shown with red rectangle and click ok.
Right click on the Data Bar column(fifth Column) and from the context menu, choose Chart Properties as shown.
In the General section of the Chart Properties window, choose Earth tones from the Color Pallet drop down.
And in the Fill section, choose Gradient in the Fill Style and provide some suitable gradients as shown.
Now Preview the Report, this completes “Chapter-12 : Working with Data Bars”
Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS
Chapter-6: Creating a Drill Down Report in SSRS
Chapter-7: Working with expressions and custom code in SSRS
Chapter-8-SSRS (Reporting Services) Working with Calculated fields
Chapter-9-Sorting of Column and Custom Paging in SSRS
Chapter-10 : Creating and Deploying Web Services for SSRS
Chapter-11 : Creating SSRS Report by consuming Web Service Data Source
Chapter-12 : Working with Data Bars in SSRS
Chapter-13-Displaying Color in Data Bar Based on Condition
Chapter-14- Displaying Data Labels along with Data Bars in SSRS
Chapter-15-Displaying Indicators in SSRS
Chapter-16-Creating SSRS Linked Report
Chapter-17 Adding or Creating Drop Down Parameter List in SSRS
Chapter-18 Creating Group above or stepped report in SSRS
Chapter-19-Creating Multi Value Parameter Report in SSRS
Chapter-20-Using CSS Stylesheet in SSRS