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.
Here, in this article we will directly start from the designing and addition of visualization in the report.
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.
Select a dataset and click on next
Choose the type of chart and click on Next. I am going to select a column chart for demo purposes.
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.
Click on Chart Title and give the name of your chart.
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.
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.
Then, run and see the result. Now you can see the value of each bar in the graph.
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.
Select Value as Count(Id) and Category Group as Branch, as illustrated below.
Right-click and select Show Labels Data to show value inside the pie chart.
Now let's run and see the report.
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.