SSRS custom code gives "#error" when report is run

Question

Hi,

For one of the reports with SSRS we have some custom code attached to one of the group footers. The report works fine in preview mode but gives an "#error" at every custom code location when the report is run. The 'Problem related post' I referred points that this is because : "Reporting Services is using the Code Access Security features of the .NET runtime"

Following the steps mentioned, I added additional permission set in rssrvpolicy.config as follows :

                        <PermissionSet 
                        class="NamedPermissionSet"
      version="1"
      Name="MyNewFilePermissionSet"
      Description="A special permission set that grants read access to my file.">
       <IPermission 
        class="FileIOPermission"
           version="1"
           Read="C:\ShipperNote.xml"/>
       <IPermission 
        class="SecurityPermission"
           version="1"
           Flags="Assertion, Execution"/>
  </PermissionSet>

I also assigned the new permission set as follows :

<CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="MyNewFilePermissionSet"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />

I still get the same error. Is there something that I am doing wrong?

Please suggest. Thanks.

Answer 1

Hi,

It sounds like there's still a permission issue. Does the user account under which SSRS executes the report have NTFS permissions to read the file?

Hope this helps, Bill

Answer 2

Hi All,

I'm facing a simillar issue. However I'm getting the error in preview mode also. This report works fine in 2005. What is changed since then? Can some one help?

Thanks!

Best Regards, MPA