migrate reports

Migrate SSRS Report from MS2011 TO Dynamics 365

Here we are trying to migrate reports from MS CRM 2011 Onprem to MS CRM D365. This will also help you for below error or if you are migrating reports from older version to newer version.

When trying to compile a FetchXML-based report in Visual Studio 2015 which had been developed in an earlier version of Visual Studio, we were getting the following error:

Building the report, ReportName.rdl, for SQL Server 2008 R2, 2012 or 2014 Reporting Services.


[rsErrorLoadingCodeModule] 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 system cannot find the file specified.
[rsCompilerErrorInExpression] The Language expression for the textrun ‘Table0_Details0.Paragraphs[0].TextRuns[0]’ contains an error: [BC30456] ‘Crm’ is not a member of ‘Microsoft’.

PREREQUISITE

I am mentioning this vital step because before proceeding to further steps this needs to be done.

We had already installed the CRM Report Authoring Extension for CRM 2015, but this helper dll was not being picked up by Visual Studio.

We were able to locate the dll on the SSRS Server of our CRM Development environment – in our case it was located here:

C:\Users\freedom\New folder\PFiles\MSCRM\BidsExtensions

BIDS EXTENSIONS under File section where you can see your file

but it may be elsewhere for different versions of SQL or CRM. So if you are not able to find it then you can search for Microsoft.Crm.Reporting.RdlHelper in your machine.

NOTE: GO TO FOLDER WHERE WE HAD INSTALLED BIDS EXTENSIONS.

We need to registered it in the GAC (Global Assembly Cache) on these machines. This is done by running the gacutil.exe utility. In some cases, this might be available from a normal command prompt, but we found we had to access it by running the Visual Studio 2015 ‘Developer Command Prompt for VS2015’.

On Windows 10, you can access this from the start menu like this – You need to run the programme as an Administrator, so find the programme and then Right-Click to Run As Administrator:

FOLDER WHERE WE HAD INSTALLED BIDS EXTENSIONS

With the new window open, navigate to the folder where the dll is and run the command gacutil -i Microsoft.Crm.Reporting.RdlHelper.dll

Developer command prompt code window
STEPS TO RESOLVE THIS ISSUE:

If you are compiling a report in Visual Studio and it is giving the error above, you might need to point the report to correct version of the RdlHelper.dll

Open the report in Visual Studio. select Report -> Report Properties from the menu. (This option is only available if the report is open and you have selected an element on the report designer/previewer.)

showing steps to resolve the issue

Now go to References Tab and browse to the correct version of the assembly in the BidExtensions folder, even if the RdlHelper is listed, it may be that this is the wrong version…

Earlier its version was 7.0.0.0 so we need to update it to 9.0.0.0 in my case.

In our case it was located here:  C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.Crm.Reporting.RdlHelper\v4.0_9.0.0.0__31bf3856ad364e35

showing file location

Exact location of helper will depend the version of the helper which you have installed. If you found any existing references (which are not necessary or may be different version of the dll) remove them.

Tags: No tags

Add a Comment

Your email address will not be published. Required fields are marked *