Patrick points to a great blog post about the upcoming integration of Microsoft Office SharePoint Server 2007 and SQL Server Reporting Services with SQL Server 2005 SP2- here's a quote from some of the most interesting parts:
After installing SP2, you can run Reporting Services in "native mode" (what you do now), or "SharePoint integration mode".
... since your reports are now stored in MOSS, you get document versioning (hooray!) and other MOSS features such as workflow and collaboration.
Viewing reports while in integrated mode is really nice, and will be second nature to anyone already using the existing web parts. You'll be able to view reports in either a "full page" view or inside Web Part pages. (This next part is really cool). Our Web Part controls will support Row and Filter consumers for specifying parameter values via filter Web Parts. What this means to you is you could drop two (or more, I guess) SSRS report Web Parts on a page which each display a different report filtered by date, and then filter them both using the same filter dialog. Very cool! You could even display / filter an SSRS report and Excel workbook using the same filter. Nice.
Definitely read the full post.