Professional Microsoft® SQL Server® 2008 Reporting Services

Chapter 16. Integrating Reports with SharePoint

This chapter explores the integration of SQL Server 2008 Reporting Services with the SharePoint technologies. In recent years, SharePoint has become a web portal centerpiece for collaboration and information sharing. As a result, Microsoft has tightly integrated their reporting solution with the SharePoint technologies.

Integration of SQL Server 2008 Reporting Services and SharePoint allows for a user to navigate to their intranet portal and have instant access to company information as well as personalized business reports and key performance indicators (KPIs). The reports can be embedded directly into web portal pages for seamless integration for the user.

SQL Server 2008 Reporting Services can be installed in either Native mode or SharePoint Integrated mode. In Native mode, a user would interact with Reporting Services using two web parts (Report Explorer and Report Viewer). In Integrated mode, SharePoint takes over all the duties of the Report Manager as well as adds SharePoint document management values such as a consistent and user-friendly experience, versioning, security trimming, alerts, enterprise search, and, when properly configured, the meeting of regulatory compliance requirements, to just name a few.

This chapter covers:

• A brief overview of the SharePoint technologies, including Windows SharePoint Services, Microsoft Office SharePoint Server, and SharePoint web parts

• SharePoint integration with SQL Server Reporting Services ...