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:
My FetchXML data source is configured this way:
Why is my report being generated fine in preview mode, yet when I upload it to CRM 2013 online, it displays no data?
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.