Enabling EnterpriseManagementChartControl in Visual Studio 2005
If you try editing some generic reports like Performance in Visual Studio you will get an error saying that EnterpriseManagementChartControl is not installed. The reason is that SCOM 2007 does not configure EnterpriseManagementChartControl development environment during normal install. If you like to use chart control designer in Visual Studio you would need to configure it manually. Here are the steps:
Make sure SCOM 2007 Reporting is installed.
Copy MicrosoftRSChart.dll and MicrosoftRSChartDesigner.dll from SSRS bin directory to Visual Studio private assemblies directory on your development machine.
Location of SSRS bin directory depends on the way you install SQL Sever but usually the path looks like this: \Program Files\Microsoft SQL Server\MSSQL.N\Reporting Services\ReportServer\bin
Visual Studio private assemblies directory usually could be found under \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
Find RSReportDesigner.config file in the Visual Studio private assemblies directory and add the following records to it:
<Configuration
>
<Extensions>
...
...<ReportItemDesigner>
<ReportItem Name="EnterpriseManagementChartControl"
Type="Dundas.ReportingServices.DundasChartDesigner,
MicrosoftRSChartDesigner" />
</ReportItemDesigner>
<ReportItems>
<ReportItem Name="EnterpriseManagementChartControl"
Type="Dundas.ReportingServices.DundasChart,
MicrosoftRSChart" />
</ReportItems>
<ReportItemConverter>
<Converter Source="Chart" Target="EnterpriseManagementChartControl"
Type="Dundas.ReportingServices.RSChartConverter,
MicrosoftDundasRSChartDesigner" />
</ReportItemConverter></Extensions>
</Configuration>Restart Visual Studio.
Please note that these steps will only work with SCOM 2007 SP1 RC or later releases. The files mentioned here were not a part of SCOM 2007 RTM.
Comments
Anonymous
March 28, 2008
Hi Eugene, firstly - great blog thanks for all the info. My specific question is I have followed the steps above and have downloaded the availability report locally. After copying down "Microsoft.EnterpriseManagement.Reporting.Security.dll" and "Microsoft.EnterpriseManagement.Reporting.Code.dll" in addition to the DLLs listed my report starts up but I do not see the RPB, only a series of input boxes. Is this expected behaviour? Is there anyway of having these present as they do in the operations manager console? Cheers SeanAnonymous
March 28, 2008
I should note that I have also modified the report.config file. Cheers SeanAnonymous
April 02, 2008
Hi Sean, Unfortunately the Smart Parameter block is currently only works in SCOM Windows console. You cannot use it in VS report preview window. The best report development technique I would suggest is publishing report from VS directly to SCOM SSRS instance and opening it is SCOM console for preview or "debugging". This is actually the technique we use for our reports development. Eugene.Anonymous
January 07, 2010
Can I work with SQL reporting services 2005 and still use the chart controls?Anonymous
January 07, 2010
Yes. Enterprise Management Chart Control is designed for SQL Server Reporting Services 2005.Anonymous
January 07, 2010
The comment has been removedAnonymous
January 08, 2010
The comment has been removedAnonymous
January 11, 2010
The comment has been removedAnonymous
January 13, 2010
The comment has been removed