How to create chart report from SQL Server data using SSRS?

Problem: How to create charts report from SQL Server data using SSRS?

Solution:  Charts (Report Builder and SSRS).

Today I am going to explain how charts are represented and what are they purposely used for:

There are few types of reports:

      1.       Tables

      2.       Matrix
3.       Charts

If you want to know how to launch and create a basic report Create a report SQL Server

Charts are best when you show grouping categories and sum or averages over the groups. It visualizes the totals of each category to show raise vs low in each category side by side.

Example:

In the example, I would like to show we can create a Chart report using SSDT and export the report to PDF.

Step 1: Drag a chart and choose a type of chart to represent the data.

  

Step 2: Drag report data set fields for numeric and non-numeric data to the Chart Data pane of the chart. When you click the chart on the design surface, the Chart Data pane appears, with three areas—Category Groups, Series Groups, and Values.

In the data set region, I am using the following query which I am going to use in the group by area to get counts of each employeetype.

SELECT  EmployeeID

           ,[EmployeeType] as TypeofEmployee

  FROM [dbo].[Employees]

Output: As you can see in the below image the representation makes it easier to show majority of employees in a company.