locked
Error while loading code module: ‘Microsoft.Crm.Reporting.RdlHelper, RRS feed

  • Question

  • Dear all,

    I am actually trying to customize a default CRM report on premise.

    For that I have download localy the report to modify then opening using Report builder 3.0. I have change the CRM datasource in order to match my organisation.
    All dataset querry in the report are able to collect data from CRM database but when I try to preview the report in Report builder I get the following error :

    "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.
    ----------------------------
    The definition of the report 'Main Report' is invalid.
    ----------------------------
    An error occurred during local report processing."

     

    Any idea  ?

    regards

    serge


    Your knowledge is enhanced by that of others.
    Wednesday, October 5, 2011 6:22 AM

Answers

  • reason was that this library is fetch when connection to report server is established.

    I have build the report on same machine as crm server and works ok


    Your knowledge is enhanced by that of others.
    Thursday, October 6, 2011 9:21 AM

All replies

  • Hi,

    Report Builder 3.0 supports SQL Query based reports, as per my understanding it does not support FetcXML based reporting, make sure that your report is using the SQL Filtered Views instead of the CRM Reporting FetchXml, for creating a report using filtered views via Report Builder you may refer:

    http://msdn.microsoft.com/en-us/library/gg309722.aspx

    http://www.powerobjects.com/blog/2011/01/06/creating-a-customer-location-map-in-microsoft-dynamics-crm/

     You can customize the FetchXml based reports int Dynamics CRM via Business Intelligence Development (Can install form the SQL Server 2008 Setup Disk) Stuid and you need to install CRM report Authoring extensions

    You can download report authoring extensions from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=64a09b75-8376-4b9d-aea3-8a83a1837c4d

     


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".

    Wednesday, October 5, 2011 7:48 AM
  • I am using SQL filterview.

    But what is strange is that, I have the feeling that report builder when open with a download report from CRM is fetching for some crm assembly when  connected to organisation report server.

    If I connect to crm report server with explorer and dedicated credential it connect succesfully. By placing same report server path and credential inside report builder server name it fails to connect

     The reference that it is not capable to get is defined in downloaded report from CRM, properties as shown below :

    Any ideas ?

    thnaks for help
    serge


    Your knowledge is enhanced by that of others.
    Wednesday, October 5, 2011 8:24 AM
  • reason was that this library is fetch when connection to report server is established.

    I have build the report on same machine as crm server and works ok


    Your knowledge is enhanced by that of others.
    Thursday, October 6, 2011 9:21 AM
  • I'm building it in the same machine as CRM and Report server and still having this problem.

    Any ideas so far?

    Thanks.

    PP


    Microsoft MVP Dynamics CRM | My Twitter: http://twitter.com/pabloperalta | My blog: http://weblogs.asp.net/pabloperalta | Blog en Español: http://wwww.elblogdedynamicscrm.com
    Tuesday, October 11, 2011 12:59 PM
  • Hi Serge,

    I am getting same error as you did, but can't understand the reason you posted as answer. Can you please explain your answer more.

    Thanks in advance.


    -- NMathur


    • Edited by nmathur Friday, March 30, 2012 12:13 PM
    Friday, March 30, 2012 11:21 AM
  • got it .... Microsoft Dynamics CRM Report Authoring Extension was not installed on my server.

    Downloaded it from here-

    http://www.microsoft.com/download/en/details.aspx?id=27823


    -- NMathur

    Friday, March 30, 2012 12:10 PM
  • Mmm well my EDW fails when installing the "Report Authoring Extensions" on my new SQL-2012 Server :(

    BI Development Studio  is not installed for Microsoft SQL Server 2008 Reporting Services or Microsoft SQL Server 2008 R2. Install BI Development Studio to continue.

    I'd really prefer not to to install BIDS 2008 R2 on my SQL 2012 server, suppose I have to until the sustained engineering team updates the pulishing RdlHelper code for SQL 2012.

    Geoff


    Geoff Fane

    Friday, July 27, 2012 4:32 PM
  • Try putting the Microsoft.Crm.Reporting.RdlHelper.dll in GAC(C:\windows\assembly). It worked for me.
    Monday, February 10, 2014 4:35 AM
  • I'm sorry, I see many of the answers may have worked, but the real issue was the referenced dll in the report.

    I believe the correct thing to do is in BIDS go to Report -> Report Properties -> References tab and view the assembly. In my case it was a report built in CRM 2011, but during the upgrade of my report authoring extension, there was a mismatch in the assembly's manifest definition did not match the assembly reference. Delete that assembly, then add this one:

    Microsoft.Crm.Reporting.RdlHelper.dll

    browsing to:

    <<directory where ReportAuthoringExtension exists>>\PFiles\MSCRM\BidsExtensions

    You'll then be fine.


    I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful. Michael Mayo

    Friday, February 28, 2014 2:38 AM
  • How do you add the .dll to the GAC when there is no gacutil installed?
    Thursday, October 29, 2015 4:05 PM
  • this is the correct answer that I found for crm online 2015  - what Michael D has suggested
    • Edited by Azure HA Thursday, February 11, 2016 1:47 PM
    Thursday, February 11, 2016 1:47 PM