With the recent RTM of SQL Server 2008, it was only a matter of time before there were some Reporting Services add-ons released.

Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007.

The download provides the following functionality:

A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print, and zoom.
Web application pages so that you can create subscriptions and schedules, and manage reports, models, and data sources.
Support for using standard Windows SharePoint Services features including document management, collaboration, security, and deployment with report server content types.
Source : SQL Server Reporting Services Add-in for SharePoint Technologies