SQL Server Reporting Services integration did not make it into MOSS 2007 beta 2. During the Ascend trainings, Ted and I demonstrated things like the SRS Web Part and the possibility to hook them up with the Filter Web Parts in for example a dashboard page. Unfortunately, with beta 2, we were not able to show this anymore. And no, the Web Part that comes with SQL SRS does not provide this functionality. I however read about exciting plans for the integration with SharePoint on the
Data Reference blog. He is talking about the forthcoming service pack for SQL Server 2005 Reporting Services. It all sounds very exciting.