Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Data Bars in SSRS Matrix Reports

In real-time, we mostly use the Data Bars in Matrix reports. In this article, we will show you how to create and configure the Data Bars in SSRS Matrix Reports.

TIP: Please refer to Data Bars article to understand the configuration of Data Bars in SSRS Table Reports with an example.

We are going to use the below-shown matrix report to configure the Data Bars. Please refer SSRS Matrix Report, Data Source and Dataset articles to understand the creation of Data Source, Dataset and Matrix report.

If you observe the below screenshot, It was a Drill Down Matrix report with Row Total, Column Total, and Grand Total (Pink Color Column) columns.

Data Bars in SSRS Matrix Reports

SQL Command we used as the Dataset is:

SELECT Geo.[EnglishCountryRegionName] AS [Country]
      ,Geo.[StateProvinceName] AS [State]
      ,Geo.[City]
      ,Cust.FirstName +' '+ Cust.LastName AS [Full Name]  
      ,Cust.EnglishEducation AS Education 
      ,Cust.EnglishOccupation AS Occupation
      ,Cust.[Gender]
      ,SUM(Cust.YearlyIncome) AS YearlyIncome
      ,SUM(Fact.SalesAmount)AS SalesAmount 
FROM  DimCustomer AS Cust
  INNER JOIN
      FactInternetSales AS Fact ON 
   Cust.CustomerKey = Fact.CustomerKey
  INNER JOIN
     [DimGeography] AS Geo ON
   Cust.GeographyKey = Geo.GeographyKey
 GROUP BY Geo.[EnglishCountryRegionName]
         ,Geo.[StateProvinceName] 
	 ,Geo.[City]
	 ,Cust.FirstName
         ,Cust.LastName  
         ,Cust.EnglishEducation 
         ,Cust.EnglishOccupation 
	 ,[Gender]
  ORDER BY [Country]

Data Bars in SSRS Matrix Reports

In this example, We will create and add the Data Bar on the right-hand side of the Total Column. First, let us create an Empty column by right-clicking on the Total column and select the Insert Column option and then select the Right option.

Data Bar in SSRS Matrix Report 2

Now, Drag and drop the Data Bars from Toolbox to the Empty column. When you drag the Data Bars to an Empty column, a new window called Select Data Bar Type will be opened to select the required Data Bar or Data Column from the available once. In this Data Bars in SSRS Matrix example, we are selecting Simple Data Bar, as shown in the below screenshot.

Data Bar in SSRS Matrix Report 3

NOTE: Please be careful while adding Data Bars in Matrix Report. If you place the Data Bars at Total Row, then Reporting Server will display the data bar for Totals, not for States.

Click Ok to add Data Bars toa newly created empty cell. Now, we have to configure the values of Data Bars. First, click on the Blue bar from the below screenshot will open the Chart Data window.

In this example, we want to show the Sales Amount in Data Bars. So, please drag and drop or select the Sales Amount as the Chart Value.

Data Bar in SSRS Matrix Report 4

Click on the Preview button to see the report Data Bars in SSRS Matrix preview.

Data Bar in SSRS Matrix Report 5

If you observe the above screenshot, It is providing a perfect result. However, we are unable to identify the value represented by the Data Bar (Sales Amount in each state). To resolve these situations, We have to use the Data Labels.

First, Right-click on the Blue bars. Next, select the Show Data Labels option from the context menu to show the values.

Data Bar in SSRS Matrix Report 6

Here, we Formatted the Numbers produced by the Data labels. Let’s click on the Preview tab to see the Report preview.

Data Bar in SSRS Matrix Report 7

Filed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy