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:

  1. Make sure SCOM 2007 Reporting is installed.

  2. 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

  3. 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>

  4. 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 Sean

  • Anonymous
    March 28, 2008
    I should note that I have also modified the report.config file. Cheers Sean

  • Anonymous
    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 removed

  • Anonymous
    January 08, 2010
    The comment has been removed

  • Anonymous
    January 11, 2010
    The comment has been removed

  • Anonymous
    January 13, 2010
    The comment has been removed