O'Reilly logo

SharePoint Server 2010 Administration 24 Hour Trainer by Clint Richardson, Martin Reid, Bill Crider

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 5

Managing Reporting Services

On the Site Settings page of a SharePoint site is a heading called Reporting Services. SharePoint site administrators can use these settings to schedule and display reports created from a tool called Reporting Services. Typically the reports created from this tool pull data from an external data source or a SharePoint list, and present a view of that data on the report.

This lesson shows you how to use Reporting Services to schedule the report and display it in a document library. By scheduling the report, we mean periodically refreshing the information from the report's data source. This lesson assumes someone else has already configured the Reporting Services tool and created the report. What follows is a brief description of the Reporting Services tool, whose use is beyond the scope of this lesson.

Reporting Services is a feature of SQL Server that can be integrated with SharePoint. It enables a SharePoint site owner to make schedules for creating reports and for viewing reports via SharePoint that were created in Reporting Services. The initial setup and configuration of Reporting Services is quite complex: a SQL server database administrator and a SharePoint administrator must work together to enable SharePoint Server to act as a reporting portal.

After Reporting Services is configured, reports can be created in SQL Server and published to a location on a SharePoint Server site. Alternatively, they can be uploaded to a document library ...

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