Working with Dundas Charts in SQL Server Reporting Service


Dundas data visualization provides third party chart controls for developers used for creating embedded chart based RDL reports with SQL server reporting service. Dundas also provides gauge, map and other visual controls for different Microsoft development platforms (ASP.NET, Windows Forms, SQL Reporting Services and SharePoint). Dundas charts for reporting services can be very easily incorporate into RDL reports and easy to use. These chart control offers more features, additional graph types and more reporting abilities.

Developers can now easily convert existing SQL reporting services charts by right-clicking on a native graph and converting it to Dundas chart. You can download an evaluation copy from the following URL:

Development Environment Setup

Before installing Dundas chart you must configure your Microsoft Visual Studio environment (need to install SQL server business intelligent development studio) for creating RDL report files. After installation of Dundas Chart, Microsoft Visual Studio Toolbox will have Dundas chart control in it.

Figure 1

Like any other .NET toolbox control you need to drag Dundas chart to report design view to use it. To add a new chart in your report drag and drop Dundas chart in report layout. This will open a wizard. First you need to select chart type from the dropdown and appearance theme. You can also create 3D charts by checking '3D enable' check box.

Figure 2

Next you need to create a data source (dataset) for the chart report and configure fields to be shown in the report. You can also create groups and sub groups using this screen.

Figure 3

The following SQL query is used to prepare test data (dataset) shown in the report.

  SELECT     4 AS TerritoryID, 'Southwest' AS TerritoryName, 31213459.5756 AS TotalSales, 2028874.8724140 AS TotalTax
  SELECT     6 AS TerritoryID, 'Canada' AS TerritoryName, 21501812.4574 AS TotalSales, 1397617.8097310 AS TotalTax
  SELECT     1 AS TerritoryID, 'Northwest' AS TerritoryName, 20802600.7782 AS TotalSales, 1352169.0505830 AS TotalTax
  SELECT     9 AS TerritoryID, 'Australia' AS TerritoryName, 12197515.5294 AS TotalSales, 792838.5094110 AS TotalTax
  SELECT     5 AS TerritoryID, 'Southeast' AS TerritoryName, 10570580.4225 AS TotalSales, 687087.7274625 AS TotalTax

The resulting set of the above SQL query is shown in the following screen-shot.

Figure 4

Clicking on the data tab of the RDL report opens the dataset configuration window. You can mention your dataset name and SQL statement that will be used to show report data. You can also mention stored procedure name with parameters in this window. Stored procedure parameters can be hard coded value or you can pass a value while report execution (run time) using report parameter options. While uploading the RDL report to report server data source and report parameters needs to be reconfigure.

Figure 5

On the next screen of the wizard you can set legend style, legend title, chart title, legend position etc. Legend position can be rotated 360 degree.

Figure 6

Next to see output of the report click on the preview tab of your RDL (Report Definition File). In this example I have shown country wise sales report and total tax paid per country wise. In X axis I have shown the country name and in Y axis total sales and total tax paid.

Figure 7

Advance Chart Properties

Advance chart configurations can be changed from the properties window. Using property window you can change default property of X axis, Y axis, secondary X axis and secondary Y axis. Advance properties can also be used to set font, color, margin, grid type, line style etc.

Figure 8

Integrating your RDL with ASP.NET Web Application

A RDL report with Dundas chart is a server side processing file. To use this RDL report in local ASP.NET web application, this needs to be converted to RDLC report. Next I have created an ASP.NET web application project using Microsoft Visual Studio 2008 and .NET framework 3.5 and added the converted RDLC file to the newly created project.

Next I have added a web form (.aspx page) where I have shown the report output. To render RDLC report I have also added a report viewer control to my web form and selected RDLC file in the ReportViewer tasks smart tags panel. Using choose data sources I have selected required data sources for this report.

Figure 9

Once all the configurations are complete I pressed F5 to compile and execute my report viewer application.


Microsoft has acquired Dundas data visualization intellectual property in April 2007. New chart and gauge report items are already released as part of SQL server reporting services 2008 more Dundas controls will be incorporated with next version of SQL server reporting service release.


  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Agile methodologies give development and test teams the ability to build software at a faster rate than ever before. Combining DevOps with hybrid cloud architectures give teams not just the principles, but also the technology necessary to achieve their goals. By combining hybrid cloud and DevOps: IT departments maintain control, visibility, and security Dev/test teams remain agile and collaborative Organizational barriers are broken down Innovation and automation can thrive Download this white paper to …

  • Java developers know that testing code changes can be a huge pain, and waiting for an application to redeploy after a code fix can take an eternity. Wouldn't it be great if you could see your code changes immediately, fine-tune, debug, explore and deploy code without waiting for ages? In this white paper, find out how that's possible with a Java plugin that drastically changes the way you develop, test and run Java applications. Discover the advantages of this plugin, and the changes you can expect to see …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds