Chapter-14- Displaying Data Labels along with Data Bars in SSRS

In this tutorial we are going to use the report we have created earlier in “Chapter-13-Displaying Color in Data Bar Based on Condition”. Open the report which was designed in Chapter-13 in design mode.  Double click on the Data Bar column “Chart Data”, popup will appear instantly, right click on Data Bar Column and choose Show Data Labels as shown in image.

Download Full Tutorial for Chapter-14-Displaying Data Labels along with Data Bars



Download Source Code for Chapter-14-Displaying Data Labels along with Data Bars_files

right click on Data Bar Column and choose Show Data Labels
Right click on Data Bar Column and choose Show Data Labels

The Data Label appears as shown below

Data Label in ssrs
Data Label

Right click on the Data Label i.e., on value 37 and choose the Series Label Properties as shown.

Choose the Series Label Properties
Choose the Series Label Properties




A Series Label Properties window will appear now. Go to the Border tab and set the Line Style to Solid and choose the Line color as desired as shown in the image.

Set the Line Style to Solid and choose the Line color as desired as shown
Set the Line Style to Solid and choose the Line color as desired as shown

After previewing the report, you can observe that the Data Bar and the Data Label come together in the report.

Preview of SSRS report with Data Bars and Data Labels togather
Preview of SSRS report with Data Bars and Data Labels togather

This completes “Chapter-14- Displaying Data Labels along 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

Leave a Reply

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

*

one + ten =