Search code examples
sql-serverreporting-servicesdynamics-crm-2011dynamics-crm-2013fetchxml

Report showing NO DATA when uploaded to crm online


When building a report in SSRS and viewing it in PREVIEW mode, my report is showing lots of data; however, when deploying it to CRM online 2013, this is what I am getting:

enter image description here

  1. This is CRM DYNAMICS ONLINE 2013
  2. The data source is FetchXML and does not change
  3. I've removed all filters from the report and it still displays nothing.
  4. I'm using windows authentication

My FetchXML data source is configured this way:

enter image description here

Why is my report being generated fine in preview mode, yet when I upload it to CRM 2013 online, it displays no data?


Solution

  • We discovered that the report wasn't querying the correct organization.

    The user was admin of 4 different online orgs, and while connecting, instead of specify the unique org name we left the parameter empty, that made the report point to the default prod org.

    Everything looked like was working correctly and the visual studio was showing data.

    The report was then deployed on the dev org, that didn't contain any data used by the report.

    To fix the problem and make the report worked as intended is necessary to add in the connection string the correct org unique name.

    enter image description here