I've run into a problem where when I upload my Custom Reports to Dynamics CRM it doesn't show any data in the reports. In my reports I used stored procedures which are stored in a separate database called "CustomReports". I've done a few tests to see if I could pinpoint what exactly was causing the issue but unfortunately I had no luck. Below are the list of tests that I tried:
- Uploaded a Report using my "CustomReports" database to access data from the CRM filtered views. -- No Data Returned
- Ran this exact Report in our Report Manager -- Data Returned
- Uploaded a Report using my "CustomReports" database to access data from the CRM non-filtered views -- Data Returned
- Uploaded a Report using the CRM database and filtered-views. -- Data Returned
I thought it might be related to the CRM security model until I ran Test 4 above. Now I'm completely stumped. Why is it that when I call stored procedures that use filtered views from my Custom database it doesn't show results but when I write the same query using CRM as my datasource it does return results? If anybody has run into a similar situation or has an idea on how to fix this it would be greatly appreciated.