Michael Gannotti on SharePoint +

the thread provided some information that SQL Reporting Services provides a powerful way of accessing and exposing business data to end users and ships as a part of SQL (translation: if you own SQL you already own it so why not use it?!). One of the great things about this is that it has a great integration story with SharePoint. I just was on an internal email thread about this in response to a customers questions and in the course of the thread grabbed a couple of great MSDN Articles on the subject. The two articles I forwarded are "Reporting Services and SharePoint Technology Integration" and "Viewing Reports with SharePoint 2.0 Web Parts."

For Reporting Services and SharePoint Technology Integration the article focuses on:

"You can configure a report server to run within a deployment of a SharePoint product or technology and use the collaboration and centralized document management features of Windows SharePoint Services 3.0 or Office SharePoint Server 2007 with Reporting Services. Running a report server as part of a larger SharePoint deployment provides these levels of integration:

• Shared storage.
• Shared security.
• Same site access for all business documents, including reports, report models, and shared data sources."

For the second article Viewing Reports with SharePoint 2.0 Web Parts the focus is on:

"Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode SQL Server 2005 report server or from a SQL Server 2000 Reporting Services report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic."