Tutorial Gateway

Create Pie Chart in SSRS Report Builder Wizard

by

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.

In order 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

Create Pie Chart in SSRS Report Builder Wizard 1

Once you click on the Report Builder button, SQL Server Report Builder will be opened with a starting page as shown in below screenshot.

Create Pie Chart in SSRS Report Builder Wizard 2

Create Pie Chart in SSRS Report Builder Wizard

In this example, we want to create Pie Chart in SSRS Report Builder wizard so Please select the New Report tab, and then select the Chart Wizard option as we shown below. This will be the same for Bar Chart, Column Chart etc.

Create Pie Chart in SSRS Report Builder Wizard 3

After you select the Chart Wizard option, a new window called New Chart will be opened as we shown below. If you had any existing data sets, or Shared dataset in your Report Server then use the first option otherwise, use second option. For now we are selecting the first option. I suggest you to refer the Create a New dataset in Report Builder article to understand the steps involved in creating shared dataset.

Create Pie Chart in SSRS Report Builder Wizard 4

Next, Please select the Chart you want to create. Here we are selecting the Pie chart.

Create Pie Chart in SSRS Report Builder Wizard 5

Next we have three section:

  • Available Fields: List of all the available columns in our dataset.
  • Categories: How you want to decide the Pie Chart. For example, Country, region, Color, Product Group etc
  • Values: All the Metric column name that you want to display in the Pie Chart. This will decide the Pie Slice size.

Create Pie Chart in SSRS Report Builder Wizard 6

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.

Create Pie Chart in SSRS Report Builder Wizard 7

Please choose the layout from the existing templates.

Create Pie Chart in SSRS Report Builder Wizard 8

Now you can see the auto generated report.

Create Pie Chart in SSRS Report Builder Wizard 9

Let me add the Title to the PIE chart, and expand the PIE chart so that it looks neat and clean.

Create Pie Chart in SSRS Report Builder Wizard 10

Remove the extra space around the report area, and click the Run button

Create Pie Chart in SSRS Report Builder Wizard 11

Once you click the Run button, following report will be generated.

Create Pie Chart in SSRS Report Builder Wizard 12

If you observe the above screenshot, It is providing perfect result but we are unable to identify the exact Sales. To resolve these situations, We have to use the Data Labels.

Right click on the pie chart and select the Show Data Labels option from the context menu to show the values

Create Pie Chart in SSRS Report Builder Wizard 13

Let me deploy the report to Report Manager by clicking the Save button

Create Pie Chart in SSRS Report Builder Wizard 14

After you click on the Save button, a new window called Save As Report will be opened. Here you have an option to select the local file system, or the Report Server. Let me select the Report Server

Create Pie Chart in SSRS Report Builder Wizard 15

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

Create Pie Chart in SSRS Report Builder Wizard 16

Now you can see the report inside the Report Server

Create Pie Chart in SSRS Report Builder Wizard 17

NOTE: Please refer Formatting Pie Chart article to understand the steps involved in formatting labels, legends and pallets.

Thank You for Visiting Our Blog