“Only data source using fetch data provider is permitted on this report”


    When we create a FetchXml based report in SSRS or ReportViewer for CRM 2011 Online and then try to import the report in CRM 2011 Online organization it gives the error “Only data source using fetch data provider is permitted on this report”.
The solution for this is to first download an out of the box report and then make your report.

Advertisements

6 thoughts on ““Only data source using fetch data provider is permitted on this report”

    1. Sayantan Samanta Post author

      Hi alok,

      Sometimes we face problems in running a report created in SSRS on CRM online. So one solution is download an existing OOB report
      and let all the Report Parameters be as it is just modify the report page and add your own Data Sets.

      There are actually some Report Parameters that CRM uses and its cumbersome to create them manually.

      Let me know the exact problem you are having.

      Regards.

      Reply
    1. Sayantan Samanta Post author

      Hi alok,

      It seems you are creating shared data sources. I would suggest do not create shared data sources. Instead use data source embedded into your report.

      Also check if you are not adding any kind of T-SQL or VB script in your code. It will not work in Dynamics CRM online.

      Regards,
      Sayantan Samanta.

      Reply
      1. Sayantan Samanta Post author

        Hi Johan,

        We cannot use special vb script functions to upload in Dynamics. However we can use the supported Functions available in the SSRS designer as they are native to Reporting Services.

        Regards,
        Sayantan Samanta.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s