Thursday, May 12, 2016

Dynamics CRM 2013 Microsoft.Crm.Reporting.RdlHelper error when attempting to preview a CRM report within SQL Data Tools

If you have setup your CRM 2013 Report Authoring Environment using the SQL Data Tools (Visual Studio 2010) and the CRM 2013 Report Authoring Extensions – when modifying Out of Box CRM Reports or Reports created by the CRM Report Wizard, you may encounter the following error when attempting to preview within the SQL Data Tools:

Error while loading code module: ‘Microsoft.Crm.Reporting.RdlHelper, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35. Details: Could not load file or assembly ‘Microsoft.Crm.Reporting.RdlHelper, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 or one of its dependencies.

The most common reason for this error is that the report is referencing version 5.0.0.0 of Microsoft.Crm.Reporting.RdlHelper and your Report Authoring Environment actually utilises version 6.0.0.0

To overcome this issue, you can simply do the following:

Make sure your focus is on the Report Layout

  • Go to the Report menu on the toolbar and select Report Properties 

  • Select the References section and there you should see the reference to Microsoft.Crm.Reporting.RdlHelper 
  • Edit the version number to be 6.0.0.0 (instead of 5.0.0.0) 

  • Press OK

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.