Configuring the Report Center
The Report Center site template provided with MOSS 2007 creates a site that supports KPIs, dashboards, Excel Web Access Web Parts, and reports. To configure it for additional functionality, we install and configure the SQL Server Reporting Services Add-in for SharePoint technologies provided with SQL Server 2005 SP2 and configure trusted locations for the Excel files that you will use as data sources for Excel Web Access.
Cross-Ref
For more information about using and configuring KPIs, see Chapter 16.
Configuring Reporting Services integration
You can extend the functionality of your Report Center by installing the SQL Server 2005 Add-in for SharePoint Technologies provided with SP2 for SQL Server 2005. This add-in will install the Report Viewer Web Part that is designed to display reports on your web part pages. In addition, the add-in extends the integration of SharePoint and SQL Server 2005 SP2 Reporting Services by:
Updating the Reporting Services Configuration tool so that you can configure your reporting services servers to create and manage SharePoint integrated databases
Enabling report subscriptions to be delivered to SharePoint libraries
Enabling synchronization from the SharePoint content database to the report server database so that the master reports live in SharePoint but the report server retains a copy
Mapping SharePoint permission roles to report server operations so that users that have add items permissions in SharePoint can create ...
Get Microsoft® SharePoint® Server 2007 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
