Just in case you have not seen this blog entry from Bhaskar Krishnan, member of the ConfigMgr Team. This blog is a very nice summary of the integration story between ConfigMgr 2007 R2 and SQL Server Reporting Services.
This blog entry is worth reading!