Problems Implementing My Custom Assembly:

I have created a custom assembly and copied it to my C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin and my C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer folders.

I then added a reference to my Report.

I added the following to my rssrvpolicy.config file in the ReportServer folder:
 <CodeGroup
        class="UnionCodeGroup"
        version="1"
        PermissionSetName="FullTrust">
        <IMembershipCondition
             class="UrlMembershipCondition"
             version="1"
             Url="$CodeGen$/*"
         />
 </CodeGroup>
<CodeGroup
  class="UnionCodeGroup"
  version="1"
  Name="SecurityExtensionCodeGroup"
  Description="Code group for the sample security extension"
  PermissionSetName="FullTrust">
  <IMembershipCondition
    class="UrlMembershipCondition"
    version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\CustomClassTest.dll"
/>
</CodeGroup>

I then call the function in the assembly from my report
Namespace.Class.method(Fields!Field.Value)

My Problem is this:
It works when I click Preview. The field I queried is displayed. But When I click build and deploy to view in a Browser(not Preview), I get "#Error" on the field I called the Custom Assembly.

I was told ,through another Forum, to Add the <CodeGroup> above to solve this problem thinking it was permissions or something.But, this did not fix it.

Can anyone suggest anything else I could do.

hi dillig,

i found something that may help you :
before you can deploy the report you need to copy your .dll file to the server and put it in the C:\Program Files\Microsoft Sql Server\MSSQL\Reporting Services\ReportServer\bin folder on the server. once you have copied the dll file you should be able to deploy your report to the server.

regards, Mire