Chapter 3

Configuring SharePoint Integration

What's in this chapter?

Understanding the SharePoint technologies

Getting PowerPivot going in SharePoint

Installing Reporting Services in Integrated mode

Understanding the Reporting Services settings in SharePoint

Native and Integrated mode topologies for SharePoint

This chapter explores the integration of SQL Server 2012 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 its reporting solution with the SharePoint technologies.

Integrating SQL Server 2012 Reporting Services and SharePoint allows a user to navigate to his or her intranet portal. There the user has 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. In addition, the exciting new Power View technology can be used to explore data in an ad hoc fashion.

SQL Server 2012 Reporting Services can be installed in either Native mode or SharePoint Integrated mode. In Native mode, a user interacts with Reporting Services using two web parts (Report Explorer and Report Viewer). In Integrated mode, SharePoint takes over all the duties of Report Manager. It also adds SharePoint document management values such as a consistent and friendly user experience, versioning, security ...

Get Professional Microsoft SQL Server 2012 Reporting Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.