April 10, 2012 at 4:35 am
Hi,
I am using SSRS 2008, I want to add reference to custom assembly.
For that,
1)I had created a Visual Studio 2010 Class Library project.In that i had created a class called Utilities with following code,
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports rsCustomAssembly
Public Class Utilities
Public Function Concat(ByVal string1 As String, ByVal string2 As String) As String
Return string1 + " " + string2
End Function
End Class
2)Then written a function and build that apllication.
3)Then I copied the .dll file to,
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies
And
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin
4) Also I had Added the followind code to rssrvpolicy.config file,where rsCustomAssembly is my .dll file name
<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="rsCustomAssembly" Description="reportHelperLib. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\rsCustomAssembly.dll"
/>
</CodeGroup>
5) Then I Had added the textbox to my report and gave exprn as,
=rsCustomAssembly.Utilities.Concat("Reporting","Services")
But,Still I am Getting the Following Error ,
i)[rsErrorLoadingCodeModule] Error while loading code module: ‘rsCustomAssembly, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'rsCustomAssembly, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
ii)[rsCompilerErrorInExpression] The Value expression for the textrun ‘Textbox4.Paragraphs[0].TextRuns[0]’ contains an error: [BC30451] Name 'rsCustomAssembly' is not declared.
Please help me in this scenario.
I am waiting eagarly for the reply.
April 27, 2012 at 5:45 am
Have you registered your assembly to the GAC (Global Assembly Cache)
http://msdn.microsoft.com/en-us/library/ex0ss12c(v=vs.80).aspx
gsc_dba
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply