I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80 conflicts.
If you search on "SharePoint" in SQL BOL (Books On Line) there are some good links to configure both on the same machine.
Here is some initial reasearch I have done.
Great doc! http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
There is also a reporting services add-in for SharePoint:
It also may be possible to host SSRS reports in the context of a SharePoint PageViewer control, but I haven't gotten that far yet.
Here is the SQL BOL Content:
You can run a report server and Microsoft Windows SharePoint Services together on a single Microsoft Internet Information Services (IIS) 6.0 server as long as each service runs in a different application pool and you add the Reporting Services virtual directories to the Windows SharePoint Services list of exclusions.
You can install Reporting Services and Windows SharePoint Services in any order.
For best results, install the report server instance using the installation option that copies the program files to disk and performs minimal configuration. In the SQL Server Installation Wizard, this is the Install but do not configure server option. Use the Reporting Services Configuration tool after Setup is finished to complete the report server deployment.
Windows SharePoint Services can be downloaded from the Microsoft Download site. The executable that installs the service is stsv2.exe. To install Windows SharePoint Services, choose a computer that is running Windows Server 2003 with IIS 6.0 in Worker Process Isolation Mode and ASP.NET enabled.
The following steps explain how to run Windows SharePoint Services and Reporting Services together after both products are installed. You can configure the report server for deployment before or after the following steps are complete.
STSADM.EXE -o addpath -url http://localhost/ReportServer -type exclusion
STSADM.EXE -o addpath -url http://localhost/Reports -type exclusion