I recently wanted to show a dynamic SQL RS report in CRM using customization of the sitemap.

I had some problems with the dymanic functionalities of the report, which didn’t work. After some work, I found that it was due to the fact that the Reporting Server had the wrong security settings in IE, and hence was prohibited to fully use the JavaScripts that controlled the drill-down of the reports. The simple solution was to add the reporting server to Local Intranet Sites in IE.

Gustaf Westerlund
CRM and SharePoint Consultant

Humandata AB