There is a known issue involving the Dynamics SQL Server Reporting Service (SRS) module and SQL Server 2005 Workgroup Edition that prevents reports from working properly. Two workarounds are needed: first, during the Dynamics CRM setup, customers must select the Custom Install option to point to the existing installation of SRS 2005. Second, customers must contact Dynamics CRM Support free of charge to receive a hotfix that allows reports to work correctly.
The workarounds will be documented in a white paper in the mid-September 2006 timeframe, and the problems are scheduled to be fixed in January 2007. For more on the installation issue, see KnowledgeBase article 921189 (http://support.microsoft.com/kb/921189/en-us); for more on the SRS 2005 issue, see KnowledgeBase article 923387 (http://support.microsoft.com/kb/923387/en-us).