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