Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

Getting Started with SSRS - Part 10 - Creating a Report with Charts

Dec 22 2011 12:00AM by Karthikeyan Anbarasan   

Introduction

In this article, we will cover how to use Charts and Gauges with the reports in the SQL Server Reporting Services. In our earlier articles, we saw how to design and deploy basic reports and some options to administer the server with basic operations on manipulations with the folder. Let us see the step-by-step process on how to use the Charts and Gauges.

Steps

Follow the earlier article steps on how to open and create a Report Server project and connect to a data source (Select * from EmployeeInfo). A screen will open as shown below which is with empty screen.

Launching the Report Designer view of the Report Project

In the left side menu we can see the number of controls available out of which we will use Charts and Gauges controls for this tutorial. Just drag and drop one chart control and two gauges control to design our report. First drag and drop a chart control. This will open a window requesting to select the type of chart as shown in the screen below.

Drag and Dropping the Chart control

Select the appropriate chart type and click on OK button. We can now see the chart is added to the report designer window as shown in the screen below.

Selected Chart Control in the Designer View

Now drag and drop 2 gauges control on to the designer view. Once we drop the Gauges control on to the designer view, again a new window will open requesting to select the type of gauge as shown in the screen below. Select the appropriate gauge and do the same for the second gauge as well.

Drag and Dropping the Gauge Control

Once we drag and drop the controls on to the designer view, we will see the report designer window as shown in the below screen.

Selected Controls in the Designer View

Now we need to configure the controls. First let’s configure the Chart control. Click the Chart control. A small popup will appear requesting for the fields as shown in the screen below.

Selecting the columns required for the Chart Control

Now select the appropriate fields for the chart control from the list and we can see the result overview as shown in the screen below.

Designer view of the selected columns for Chart Control

Next, we need to configure the gauges control in the same way as we did in the charts control as shown in the screen below.

Selecting the columns required for the Gauge Control

Once we are done with the configuration, we can build and execute the project by clicking on the RUN button or pressing F5 functional key. Once the project is built successfully, we can see the reports being generated with the charts and gauges as shown in the screen below.

Chart and Gauge Controls in Action

Conclusion

So in this article we have seen how to create a report with charts and gauges by fetching data from the SQL server.


Karthikeyan Anbarasan
52 · 4% · 1176
7



Submit

1  Comments  

  • Awesome Karthik awesome. what an article. I read all the parts and learnt the SSRS. You are too good. Site name matches with its content.

    commented on Oct 20 2012 4:44AM
    saikatmalakar
    2824 · 0% · 4

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 10 - Creating a Report with Charts" rated 5 out of 5 by 7 readers
Getting Started with SSRS - Part 10 - Creating a Report with Charts , 5.0 out of 5 based on 7 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]