Service Pack 2 for SQL Server 2005 has RTM-ed! Why do you read SQL related stuff on my blog? Well this service pack includes the long awaited Reporting Services web parts for SharePoint 2007 (WSS v3 and MOSS 2007). From the what's new page:
You can integrate a report server instance with Windows SharePoint Services 3.0 or Microsoft Office 2007 SharePoint Server to store, secure, access, and manage report server items from a SharePoint site. Integration features are provided jointly through SP2 and a special Reporting Services Add-in that you download and install on an instance of the SharePoint technology you are using.
The new Report Viewer Web Part is included in the Reporting Services Add-in that you install on a SharePoint technology instance. For more information about the Web Part and other integration features, see Reporting Services and SharePoint Technology Integration and Features Supported by Reporting Services in SharePoint Integration Mode.
Get it from the MS Download site!