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