Dynamics Community Forum Thread Details

CRM 2015 Report Wizard generates report with CRM 2011 references

Hello,

I was having trouble scheduling a report, it just would not run on the schedule. SSRS (this is on-prem) logs indicated:

processing!WindowsService_72!984!09/27/2016-15:54:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.;
library!WindowsService_72!984!09/27/2016-15:54:01:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
library!WindowsService_72!984!09/27/2016-15:54:01:: e ERROR: Schedule 1ff9c237-3fae-4b53-9080-d8fad593006c failed. Error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Failed to load expression host assembly. 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 located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Failed to load expression host assembly. 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 located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

and found the solution on https://blogs.msdn.microsoft.com/emeadcrmsupport/2014/10/17/dynamics-crm-2013-microsoft-crm-reporting-rdlhelper-error-when-attempting-to-preview-a-crm-report-within-sql-data-tools/

It says "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"

I checked the RDL and sure enough, the reference is to 5.0.0.0:
<CodeModules><CodeModule>Microsoft.Crm.Reporting.RdlHelper, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule></CodeModules>

I edited the RDL to show 7.0.0.0 (we are on CRM 2015) and re-uploaded the report.

I then chose to Schedule Report from the Reports listing in CRM, which creates a copy of that report - this new copy had the 5.0.0.0 reference again!

I downloaded that RDL, edited to 7.0.0.0 and re-uploaded from within SSRS, and the scheduled report started coming off just fine.

So at least on my deployment, the Report Wizard is referencing the wrong version of the assemblies. Wondering if this can be somehow corrected, or if anyone else can reproduce the same issue?

Quick Links

Leaderboard