The SSRS 2008 R2 Report Server in SharePoint mode allows integrating with SharePoint 2007:  

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

HTH,
Prash