Pie And Bar Chart Design In SSRS (RDL) Report Using Microsoft Report Builder

Introduction

 
SSRS (RDL) Report Design Using Microsoft Report Builder contains the introduction including necessary steps and a description of how to add a data source, dataset, and tabular report using MS Report Builder. Using Microsoft Report Builder, we can design Report and Dashboard including several types of visualization such as Pie, Bar, Scatter, Pyramid, Funnel, Line, Line and Bar combination and many more for business intelligence and data analysis.
 
This article describes the straightforward steps to represent the data in the form of Bar graph and Pie chart in reports using the Microsoft Report Builder tool which is an essential component of the SSRS Report building process to build reports faster and graphically represent data. Those reports can be published in Report Server of SQL Server reporting services (SSRS). Bar Graph, Pie chart, Line Graph, Scatter plot, etc. are more popular and useful visualizations to represent the data in the dashboard and graphical reports. This article will take an example of the total number of employees in each branch and depict those in a Bar Graph and Pie Chart. However, we can add several visualizations in the report and dashboard using MS Report Builder as per our need.
 
Prerequisites
  1. SQL Server
  2. SSRS (SQL Server Reporting Services)
  3. MS Report Builder
This article is continuing from the previous part. So, if you are new to Microsoft Report Builder or if you face any issues connecting with database, please follow the steps from 1 to 11 from previous article. SSRS (RDL) Report Design Using Microsoft Report Builder
 
Here, in this article we will directly start from the designing and addition of visualization in the report.
 

Bar Graph Design

 
To design a chart in your report or dashboard, go to the insert option click on the chart, and then the chart wizard as illustrated below.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Select a dataset and click on next
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Choose the type of chart and click on Next. I am going to select a column chart for demo purposes.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
In this stage, you can select the fields as per your report requirement. In my case, I am going to show the number of employees available in each branch. Thus, I have dragged the Id field in values and branches in categories. After that, click on next.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Click on Chart Title and give the name of your chart.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Now, it's time to run and see the report. To run the report, click on Run. Your report will look like as shown below.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
To show the value of each branch in the graph Go to top of the bar -> Right-click on the bar graph and click on Show Data Labels. It will show the data of each bar on the top.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Then, run and see the result. Now you can see the value of each bar in the graph.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Pie Chart: Pie Chart is one of the mostly used visualizations to represent data in reports and dashboard. Now, we will learn how to add Pie chart in the report. To add a pie chart, similarly, go to the chart and select chart type pie, choose the shape of the pie here I am going to choose a doughnut shape pie chart.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Select Value as Count(Id) and Category Group as Branch, as illustrated below.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Right-click and select Show Labels Data to show value inside the pie chart.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 
Now let's run and see the report.
 
Build SSRS (RDL) Report From Microsoft Report Builder
 

Summary

 
In this way, we have represented the number of employees in different branches in graphical view: Bar graph and Pie chart. Similarly, we can add other visualizations in the report and dashboard to make more meaningful and attractive. Overall, this article described detailed steps of designing Bar graph and Pie chart in reports using Microsoft Report Builder tool one of an essential part of SSRS reports with an example of the number of employees in Branch. I hope, this article will help you to learn and design reports and dashboard using user friendly and free tool Microsoft Report Builder.