Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 1st, 2004, 10:48 AM
Authorized User
 
Join Date: Jun 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Implementing Custom Assemblys

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.


 
Old September 8th, 2004, 07:56 AM
Registered User
 
Join Date: Sep 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Server Control....Custom Property Editor ZArrinPour ASP.NET 1.0 and 1.1 Basics 1 June 15th, 2010 11:30 AM
Sorting Difficulties when implementing Custom Obj sandyl BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 12 July 28th, 2008 04:24 PM
Web Service, Custom Control, Custom Return Type robzyc ASP.NET 2.0 Basics 6 June 10th, 2008 08:03 AM
Custom Assemblys dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 2 July 15th, 2004 10:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.