Dundas control is powerful 3rd party tool to develop report using SQL Server Reporting Service.
Microsoft declared that they integrated Dundas Control with SQL Server Reporting Service 2008 but in reality I found that I had to install Dundas control in my SQL Server Report Service 2008 server to make my reports working, which is little disappointing.
Another disappointing thing is, you need to manually setup the configuration files every time you deploy your reports in a new server even after installing Dundas Control.
If you see the following error “The Dundas Chart for Reporting Services report item is unavailable” even after installing Dundas Control for SQL Server reporting Service you need to do the following things to make it working.
1. Modify C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\rsreportserver.config
2. Modify C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\rssrvpolicy.config
3. Remember if you use any external dll files for your report you need to add the reference manually too in C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\rssrvpolicy.config
You will get the config code for all the configuration here http://support2.dundas.com/Default.aspx?article=1107, so just copy paste the configurations in you server’s configuration files and restart the SQL Server Report Service. Hope now your reports with Dundas controls are working now. happy reporting 🙂