none
Reporting Services & CRM Online 2011 / SQL Server Express

    Question

  • I love the fetch xml method for writing SSRS reports for CRM Online 2011. I don't have an available SQL Server with reporting services, is it possible to run reports from SQL Server Express?


    Senior Consultant / Project Manager CRM
    Friday, August 26, 2011 10:48 PM

All replies

  • I can't get rid of this:

    An error occurred during client rendering.

    An error has occurred during report processing.

    An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services.


    Senior Consultant / Project Manager CRM
    Saturday, August 27, 2011 10:09 AM
  • Hi,

    You can not run SSRS Reports using FetchXML reporting unless you install Dynamics CRM 2011 Reporting Services Extensions and it can be only install if you have CRM 2011 server installed and it requires SQL Server 2008 64 bit Standard or Enterprise edition. It will not working with SQL express edition.


    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".
    Saturday, August 27, 2011 10:12 AM
  • Thanks for your reply.

    It's hard to accept that I can preview my Reports in BIDS, but not publish them in SSRS.

    Could someone please make a data extension for SSRS? :-)


    Senior Consultant / Project Manager CRM
    Saturday, August 27, 2011 10:26 AM
  • Hi,

    The SSRS Reporting Extensions are already available from Microsoft but it will be only installed for CRM On-Premise (Company hosted) versions. Without CRM 2011 installed you can not publish your reports to SSRS. Try to understand because on installing CRM 2011 the database will be deployed and other required components and then only you will be able to published SSRS reports. As i mentioned above CRM 2011 requires SQL Server 2008 64 Bit Standard or Enterprise editions and also SQL Server Reporting Services express additions has limitations thats why it can not be work.

    You can deploy your reports on CRM 2011 Online for testing purposes.


    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".
    Saturday, August 27, 2011 10:33 AM
  • No, I don't understand. With a SSRS extension for reading XML queries, this should be possible in my head...:-)

    Sunday, August 28, 2011 8:08 PM
  • Hi,

    You should better look into the Sql Reporting Services Planning Requirements(http://technet.microsoft.com/en-us/library/hh386538.aspx), it is clearly mentioned that Custom FetchXml based Reports will only work via SQL Reporting Sevrices Reporting Extensions and it is also mentioned very clearly that You must complete Microsoft Dynamics CRM Server Setup before you run the Microsoft Dynamics CRM Reporting Extensions Setup. 


    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".
    Sunday, August 28, 2011 9:31 PM
  • Thanks againg for your replies, but I still think you miss the fact that I just want SSRS to understand the Microsoft Dynamics CRM Fetch schema (like BIDS/Visual Studio do).

    How can I add (or maybe write/reuse the BIDS extension) to SSRS??

    Sunday, August 28, 2011 10:31 PM
  • Hi,

    Just adding further clarfications if you want BIDS to understand the Fetch Schema then you have to install Microsoft Dynamics CRM Report Authoring Extension (http://technet.microsoft.com/en-us/library/gg554856.aspx) and to udner SSRS the fetch Schema you need to install the Microsoft Dynamics CRM Reporting Extensions (http://technet.microsoft.com/en-us/library/hh386538.aspx)


    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".
    Sunday, August 28, 2011 10:59 PM
  • Take a look at this: http://msdn.microsoft.com/en-us/library/bb326409.aspx

    As far as I can understand it is possible to register a new dataprovider for SSRS.

    I wonder If I could copy the right dll from CRM Reporting Extension and deploy it in SSRS as described in the URL abobe.

    Monday, August 29, 2011 8:23 AM
  • Hi,

    You may try but it is not possible to register with SQL Server Express edition, it is a free version and it comes with many limitations  then SQL Server Reporting Services Standard and Enterprise editions.


    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".
    • Proposed as answer by Jehanzeb.Javeed Thursday, September 01, 2011 3:04 PM
    Thursday, September 01, 2011 2:15 PM
  • Hi

    I am relatively new to MSCRM 2011 so kindly bear with me.

    Ok, I am developing a report using FETCH Xml (A simple query Account containing data (3-4 records)).

    I have installed SQL Server 2008 and BIDS extension for reporting as well.

    I created the report by making a data source (FETCH type) and completed the wizard.

    When I am previewing the report I am getting all the data. But, as soon as I try to Run it I get this error

    “An error occurred during local report processing

    An error has occurred during report processing.

    As attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services”

     

    I have already installed rollup 4 on CRM server L

    Can any one please revert back

    Cheers

    Bharat

    Tuesday, October 18, 2011 1:59 PM