Chapter-12 : Working with Data Bars in SSRS

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.

Download Full Tutorial for Chapter-12-Working-with-Data-Bars

Download Source Code for Creating Data Bars in SSRS

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.

Data bars in SSRS

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.

Rename the Label of fifth column
Rename the Label of fifth column

Please choose the “Stacked bar” Data Bar type as shown in the image as shown with red rectangle and click ok.

Please choose the "Stacked bar" Data Bar type
Please choose the “Stacked bar” Data Bar type

Right click on the Data Bar column(fifth Column) and from the context menu, choose Chart Properties as shown.

Choose Chart Properties as shown
Choose Chart Properties as shown

In the General section of the Chart Properties window, choose Earth tones from the Color Pallet drop down.

Choose Earth tones from the Color Pallet drop down
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.

, choose Gradient in Choose the Fill Style and provide some suitable gradients
Now Preview the Report, this completes “Chapter-12 : Working with Data Bars”

Preview of SSRS Data Bar
Preview of SSRS Data Bar

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
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

Leave a Reply

Your email address will not be published. Required fields are marked *


three + one =