SSRS CustomReportItem deploying issue.

• nbethi

  SSC-Addicted

  Points: 408

  More actions

  June 7, 2013 at 5:07 am

  #294918

  We have a custom report developed in 2005 item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

  Recently we have migrated our reporting server to 2012 but reports still continuing with the old rdls (rdls never migrated to 2012).

  1. Deployed the report using Visual Studio

  2. updated the rsreportserver.config file with the following entry:

  <ReportItems>

  <ReportItem Name="RiskMap" Type="RiskMapCRI.RiskMapRender, RiskMapCRI"/>

  </ReportItems>

  <ReportItemDesigner>

  <ReportItem Name="RiskMap" Type="RiskMapCRI.RiskMapDesigner, RiskMapCRI"/>

  </ReportItemDesigner>

  3. Updated the rssrvpolicy.config file with the following entry.

  <CodeGroup

  class="UnionCodeGroup"

  version="1"

  PermissionSetName="FullTrust"

  Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">

  <IMembershipCondition

  class="UrlMembershipCondition"

  version="1"

  Url="C:\Program Files\Microsoft SQL Server\MSSQL.11\Reporting Services\ReportServer\bin\RiskMapCRI.dll" />

  </CodeGroup>

  I've also tried using the StrongNameMembershipCondition with no better results.

  4. The dll and its dependencies are copied to the bin directory of the report server.

  5. When I load a report with this custom report item on it, the report loads fine with no errors.The area where the custom item should be is just white or sometimes the below error is displayed.

  This is particularly frustrating because the report works fine in Visual Studio.

  When report is accessed, below error is displayed.

  -----Error shown on report--------------------

  An error has occurred during processing of the CustomReportItem 'riskMap1' with the 'RiskMap' extension. (rsCRIProcessingError)

  Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

  -------------------------

  Error from Log file:

  =====================

  tServer_0-2!8a8!06/07/2013-04:09:43:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during processing of the CustomReportItem 'riskMap1' with the 'RiskMap' extension. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An error has occurred during processing of the CustomReportItem 'riskMap1' with the 'RiskMap' extension. ---> System.BadImageFormatException: Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

  File name: 'Microsoft.ReportingServices.Designer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

  at RiskMapCRI.RiskMapRender.Process()

  at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICollection.CreateInstance(ReportItem reportItem, Boolean setupEnvironment, Int32 index)

  ================

  Need urgent help.

  Not able to find any fix for this issue.

  Looking for immediate help.