Skip to Main Content
Professional Microsoft SQL Server 2012 Reporting Services
book

Professional Microsoft SQL Server 2012 Reporting Services

by Paul Turley, Robert M. Bruckner, Thiago Silva, Ken Withee, Grant Paisley
June 2012
Intermediate to advanced content levelIntermediate to advanced
912 pages
23h 35m
English
Wrox
Content preview from Professional Microsoft SQL Server 2012 Reporting Services

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft SQL Server 2012 Reporting Services

Microsoft SQL Server 2012 Reporting Services

Stacia Misner
Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein

Publisher Resources

ISBN: 9781118237137Purchase book