locked
SSRS report that queries non-CRM SQL data RRS feed

  • Question

  • Developed a report that queries Dynamics AX SQL data and runs successfully from SSRS report manager, but if I import into CRM it will not run and gives an rsProcessingAborted error.  On the AX SQL server the event viewer gives an error that SQL cannot allow anonymous access.  It seems as though when the report gets imported into CRM the data source gets changed somehow.  Any suggestions?
    Friday, January 11, 2013 8:33 PM

Answers

  • Christian,

    I was able to get this to work by doing the following:

    1. Open Internet Explorer and go to http://ssrs-server/reports 
    2. Navigate into the CRM organization folder where the custon report resides, i.e. Organization_MSCRM
    3. Click the Details View button on the upper right navigation bar
    4. Navigate into Custom Reports folder
    5. Select the newly imported report and select Manage from the drop down menu on the report
    6. Choose Data Sources and setup the data source to select the external data needed.
    • Marked as answer by William Mann Tuesday, January 15, 2013 1:11 AM
    Tuesday, January 15, 2013 1:11 AM

All replies

  • Hi William

    You are right. As the report gets uploaded to CRM all database connection strings gets changes so that they point towards the specific CRM organization database. You then get an error because you reference tables or views that do not exist in the CRM database. I had the same problem some time back and the only work-around I was able to use was to create a button on the CRM form that calls the report on the report server. You can add parameters to the url.

    http://www.mssqltips.com/sqlservertip/1336/pass-parameters-and-options-with-a-url-in-sql-reporting-services/  

    It's probably not what you hoped for I'm not aware of any other alternative.


    Friday, January 11, 2013 11:09 PM
  • Could you just include the report on a dashboard instead? or on a form if it needs some CRM context to be passed as parameters? (either in an iFrame or possibly using the Report component web resource)

    Hope this helps.
    Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
    Blog: Getting IT Right

    Saturday, January 12, 2013 8:45 AM
  • Christian,

    I was able to get this to work by doing the following:

    1. Open Internet Explorer and go to http://ssrs-server/reports 
    2. Navigate into the CRM organization folder where the custon report resides, i.e. Organization_MSCRM
    3. Click the Details View button on the upper right navigation bar
    4. Navigate into Custom Reports folder
    5. Select the newly imported report and select Manage from the drop down menu on the report
    6. Choose Data Sources and setup the data source to select the external data needed.
    • Marked as answer by William Mann Tuesday, January 15, 2013 1:11 AM
    Tuesday, January 15, 2013 1:11 AM