Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Custom Assemblies - SQL Server Reporting Services

RSS
Modified on Sat, May 01, 2010, 8:39 AM by Administrator Categorized as SSRS (SQL Server Reporting Services)
To reference custom assemblies in SSRS, several rules have to be followed in order for it to work.

Creating the Assembly

(1) Create a Class Library in Visual Studio

(2) Name the project CodeReportingLibrary

(3) Rename the class CodeReportingFunctions

(4) Import the System.Security.Permissions namespace

(5) Add the following code to the beginning of every method.

SqlClientPermission oPerm = new SqlClientPermission(
      PermissionState.Unrestricted);
   oPerm.Assert();

Using the Assembly

(1) Install the DLL in the folder C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.

(2) Add a reference to the new assembly from your report via the Report menu > Report Properties > References tab.

(3) Call functions from this library via the following syntax: =CodeReportingLibrary.CodeReportingFunctions.MyFunction(Fields!CustomerId.Value.ToString())

Deploying the Assembly

(1) To deploy the DLL to the report server, copy it to the folder C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin.

(2) Adjust the security policy file for SSRS within C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config.

(3) Search for $CodeGen$ within the configuration file.

(4) Add the following code below that code group's ending element.
<CodeGroup 
     class="UnionCodeGroup"
     version="1"
     PermissionSetName="FullTrust"
     Name="CoDeMagSample"
     Description="CoDe Magazine Sample. ">
     <IMembershipCondition
       class="UrlMembershipCondition"
       version="1"
       Url="C:\Program Files\Microsoft SQL Server\
          MSSQL.3\Reporting Services\ReportServer\bin\
       CoDeReportingLibrary.dll"
     />
   </CodeGroup>

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.