While preparing for my presentation at MMS 2009, Demystifying ConfigMgr 2007 R2 Reporting Services, I stumbled onto an issue that at first I thought was a deployment mistake.
In a previous blog, I posted the information for deploying a report model to the ConfigMgr MMC:
Step-by-Step Guide to Deploying a Report Model to Configuration Manager
http://technet.microsoft.com/en-us/library/dd504761.aspx
It turns out that it works perfectly when creating a report model in SQL Server 2005.
However, when a report model was created using SQL Server 2008, and deployed to the ConfigMgr MMC, attempting to launch a create report wizard causes the wizard to crash with an error.
In checking with Microsoft, it turns out that the ConfigMgr MMC/reporting framework was built using the SQL Server 2005 schema, not SQL Server 2008.
So if you develop report models using SQL Server 2008, simply deploy them to the Report Server. They can be used with Report Builder 2.0 or BIDS, just not with the ConfigMgr R2 MMC.