In this article, we will show you how to create Pie Chart in SSRS Report Builder Wizard. Or we can say, steps involved in creating Pie Chart using SSRS Report Builder.
To create a Pie Chart or any Report, we have to open the report builder. To do this, Please open your report manager and click on the Report Builder button as shown in below screenshot
Once you click on the Report Builder button, SQL Server Report Builder will open with a starting page.
Create Pie Chart in SSRS Report Builder Wizard
In this example, we want to create a Pie Chart in the SSRS Report Builder wizard. So, please select the New Report tab and then select the Chart Wizard option. It will be the same for Bar Chart, Column Chart.
After you select the Chart Wizard option, a new window called New Chart will open. If you had any existing data sets or Shared dataset in your Report Server, then use the first option; otherwise, use the second option.
For now, we are selecting the first option. I suggest you refer the Create a New dataset in Report Builder article to understand the steps involved in creating a shared dataset.
Next, Please select the Chart you want to create. Here we are selecting the Pie chart.
Next, we have three sections:
- Available Fields: List of all the available columns in our dataset.
- Categories: How you want to categorize the Pie Chart. For example, Country, region, Color, Product Group
- Values: All the Metric column names that you want to display in the Pie Chart. It decides the Pie Slice size.
We are adding the Title to categories, and Sales Amount Column to Values. It means our pie chart will show you the Sales Amount by Employee Title.
Please choose the layout from the existing templates.
Now you can see the auto-generated report.
Let me add the Title to the PIE chart, and expand the PIE chart so that it looks neat and clean.
Remove the extra space around the report area, and click the Run button
Once you click the Run button, the following report will generate.
Right click on the pie chart and select the Show Data Labels option from the context menu to show the values
Let me deploy the report to the Report Manager by clicking the Save button
After you click on the Save button, a new window called Save As Report will open. Here you have an option to select the local file system or the Report Server. Let me select the Report Server
Let me open my Report Server to show the newly created Table Report. Here, If you want to see the report preview, or Run the report, then you don’t have to access the Report Builder or BIDS. Just click on the report will run the report. Let me select the report that we saved previously and click on it
Now you can see the report inside the Report Server
NOTE: Please refer to Formatting Pie Chart article to understand the steps involved in formatting labels, legends, and pallets.