The SSRS 2008 R2 Report Server in SharePoint mode allows integrating with SharePoint 2007:
- Supported configuration: SSRS 2008 R2 is supported on SharePoint 2007 with the SSRS 2008 RS Add-in for SharePoint version SP2 onwards. This can now be downloaded from : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en. Additionally, details on SP2 can be found @ http://blogs.technet.com/b/dataplatforminsider/archive/2010/09/29/sql-server-2008-sp2-is-available-for-download-today.aspx
(outdated information: The timeline for SP2 is no earlier than Sept. 2010, having said that you can consider trying out the functionality / this configuration using the latest SSRS 2008 SP2 CTP version of this Add-in available @ http://www.microsoft.com/downloads/details.aspx?FamilyID=65606fdd-093f-4c70-91f6-dc1f24520e8f&displaylang=en )
- Features available: In this configuration features available include Alternate Access Mapping, SharePoint List Reporting extension in connected mode, Report Builder 3.0 with Report Parts, ATOM Renderer, RS.EXE enabled to script against SharePoint mode, etc.
- Features not available: Key features not avilable include Out-of-the-box (OOTB) Local mode reporting, AJAX ReportViewer, ULS logging, etc.
For details on features supported by SSRS 2008 R2 Report Server with SharePoint 2007 refer to http://msdn.microsoft.com/en-us/library/bb326290(v=SQL.105).aspx