Deploying a Custom Report Item

New: 5 December 2005

To deploy a custom report item in SQL Server 2005 Reporting Services, you must modify the report server configuration files and copy the design-time and run-time component assemblies into the appropriate application folders for both Report Designer and the report server.

To deploy a custom report item

  1. Edit the rsreportdesigner.config file to configure the custom report item run-time and design-time components for use in the designer. Note that the ReportItemName entry must match the CustomReportItemAttribute attribute used in your CustomReportItemDesigner class. For example:

    <ReportItems>
       <ReportItem Name="Polygons" Type="Microsoft.Samples.ReportingServices.PolygonsCCustomReportItem,PolygonsCRI"/>
    </ReportItems>
    <ReportItemDesigner>
       <ReportItem Name="Polygons" Type="Microsoft.Samples.ReportingServices.PolygonsDesigner, PolygonsDesigner" />
    </ReportItemDesigner>
    <ReportItemConverter>
       <Converter Source="Chart" Target="Polygons" Type="Microsoft.Samples.ReportingServices.PolygonsConverter, PolygonsDesigner" />
    </ReportItemConverter>
    
  2. Edit the rsreportserver.config file to register the custom report item run-time component. For example:

    <ReportItems>
       <ReportItem Name="Polygons" Type=" Microsoft.Samples.ReportingServices.PolygonsCCustomReportItem,PolygonsCRI"/>
    </ReportItems>
    
  3. Edit the rsssrvpolicy.config file to add a CodeGroup that grants the proper permissions to the custom report item. For example:

    <CodeGroup 
       class="UnionCodeGroup" 
       version="1" 
       PermissionSetName="FullTrust"
       Description="This code group grants MyCustomReportItem.dll FullTrust permission. ">
       <IMembershipCondition 
          class="UrlMembershipCondition"
          version="1"
       Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\MyCustomReportItem.dll" />
    </CodeGroup>
    
  4. Copy the custom report item run-time component DLL to the \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies and \Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin directories.

  5. Copy the custom report item design-time component DLL to the \Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies directory.

See Also

Concepts

Custom Report Item Class Libraries

Other Resources

Reporting Services Configuration Files
Custom Report Item Sample

Help and Information

Getting SQL Server 2005 Assistance