Using the Reporting Services web parts in Office SharePoint Server 2007
If you want a list of available reports and a report viewer web part in Office Server 2007 then you need to import these web parts.
By default you can find the web parts from SQL Server 2005 in this directory:
"C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"
U can use the stsadm tool from sharepoint to import these webparts into Office Server 2007 using this statement
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"
Read more about this here
In the next Service Pack for SQL Server (SP2) a richer integration will be available between SQL Server Reporting Services and Office Server 2007, more on this later.