O'Reilly logo

Microsoft® SharePoint® Server 2010 Bible by Steven Mann

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Using Reporting Services and Report Libraries

IN THIS CHAPTER

  • Configuring the Reporting Environment

  • Managing data sources, models, and data connections

  • Managing reports and models

  • Implementing the Report Viewer Web Part

The Report Library template provided with SharePoint 2010 is a powerful tool for displaying reports and metrics for your organization. The Report Library combines the capabilities for providing status and trend information by using KPIs with the dashboard capability for combining Web Parts into a page so that related information from a variety of sources give users a full view.

In this chapter, we extend the Report Library functionality by installing and configuring the SQL Server 2008 R2 Reporting Services Add-in for SharePoint technologies so that SharePoint document libraries can store and manage reporting services reports, models, and data sources. This add-in also installs a Report Viewer Web Part that is designed to display reports in a dashboard or Web Part page.

Configuring the Reporting Environment

The Report Library template provided with SharePoint 2010 creates a library that supports Excel reports and Status List Web pages. To configure it for additional functionality, we install and configure the SQL Server Reporting Services Add-in for SharePoint technologies provided with SQL Server 2008 R2 and configure trusted locations for the Excel files that you will use as data sources for Excel Web Access.

Configuring Reporting Services integration

You can ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required