Build a SSRS(RDL) Report from Microsoft Report Builder Part 1 contains the introduction including necessary steps and a description of how to add a data source, dataset, and tabular report using MS Report Builder. 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. 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 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 depicts those in Bar graph and Pie Chart.
Bar Graph Design
To design a chart, go to the insert option click on the chart, and then the chart wizard.
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 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 on top of the bar -> Right-click on the bar graph and click on Show Data Labels.
Run and see the result. Now you can see the value of each bar in the graph.
Pie Chart: 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.
Conclusion
In this way, we have represented the number of employees in different branches in Graphical view: Bar graph and Pie chart. 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.