locked
When I install an SRS Report in the Report area of CRM - getting error RRS feed

  • Question

  • Hi

    I have created an srs report and it runs just fine and gets proper data when I run in the Report Builder

    When I add this rdl file to CRM then click the Save button, I get an error message

    How do I fix this?

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Error occurred while setting the data source.Detail:
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
      <ErrorCode>-2147187934</ErrorCode>
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Error occurred while setting the data source.</Message>
      <Timestamp>2013-08-21T13:21:31.9683952Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
    </OrganizationServiceFault>

    Wednesday, August 21, 2013 1:22 PM

Answers

  • Hi,

    Please check the datasource name in the report. Please prefix the Data source name with MSCRM_ . So Data Source name will be MSCRM_DataSource (the name of the datasource).

    Please also make sure that you are not using any shared Data source in the report.

    Thanks!

    • Proposed as answer by Kalim Khan Tuesday, August 27, 2013 10:46 AM
    • Marked as answer by katiemackie Tuesday, August 27, 2013 10:50 AM
    Wednesday, August 21, 2013 5:25 PM

All replies

  • Hi,

    Please check the datasource name in the report. Please prefix the Data source name with MSCRM_ . So Data Source name will be MSCRM_DataSource (the name of the datasource).

    Please also make sure that you are not using any shared Data source in the report.

    Thanks!

    • Proposed as answer by Kalim Khan Tuesday, August 27, 2013 10:46 AM
    • Marked as answer by katiemackie Tuesday, August 27, 2013 10:50 AM
    Wednesday, August 21, 2013 5:25 PM
  • By report builder, are you referring to the Report Wizard in Business Intelligence Development Studio?
    Thursday, August 22, 2013 5:58 AM