An overview of integrating SQL Server Reporting Services with the Report Center

This article provides an overview of what is required to integrate SQL Server 2005 Reporting Services with the Report Center in Microsoft Office SharePoint Server 2007. You will see how the various server components work together, and you will learn about links added to the Quick Launch when using the Report Center template that broaden SharePoint reporting capabilities using Reporting Services integration.

Integrating Reporting Services with the Report Center requires that the following components be installed.

SQL Server 2005 Reporting Services

Hosts Reporting Services reports and communicates with Office SharePoint Server 2007 by using a Web Services interface. The Reporting Services server also manages subscriptions and report caching. This server can be separate from the server running Office SharePoint Server 2007, but you must do a basic install of Microsoft Office SharePoint Server 2007 on the Reporting Services server to ensure that the Windows SharePoint Services 3.0 object model is installed.

SQL Server 2005 Service Pack 2

Enables Office SharePoint Server 2007 and Reporting Services integration on the report server.

Office SharePoint Server 2007

Serves as the central access point for all reports and business data. Alternately, you can use Windows SharePoint Services 3.0.

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

Includes the Report Viewer Web Part and the new report management user interface.

The following diagram demonstrates how the various components work together.

Integration diagram

Top of Page

Integration with SQL Server 2005 Reporting Services

SQL Server 2005 enables deep integration between Reporting Services and Microsoft SharePoint products and technologies (Windows SharePoint Services 3.0 and Office SharePoint Server 2007). The Report Center — a site template included with Office SharePoint Server 2007 — supports integration with SQL Server 2005 Service Pack 2 (SP2). This integration enables you to use the Report Center to view and manage reports directly from a SharePoint document library. Integrating Reporting Services with Office SharePoint Server 2007 is referred to — from the SQL Server 2005 side — as SharePoint Integration Mode. Having Reporting Services host reports in the reporting services database only, and not integrating with Office SharePoint Server 2007, is referred to as Native Mode.

Note: Integration between Reporting Services and Office SharePoint Server 2007 requires some configuration before it will work. After you have installed the above components on the report server and the server running Office SharePoint Server 2007, you must configure each server. For more information about how to integrate SQL Server 2005 Reporting Services with Office SharePoint Server 2007, see the article 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005 or talk to your administrator.

Integration with Report Center

While Reporting Services reports can be managed in any site or document library, Office SharePoint Server 2007 includes the Report Center site template as an out–of–the–box feature for business reporting, and the Report Center is used to create a SharePoint site for hosting reports. When you create a site by using this template, links are added to the Quick Launch so that you can easily manage reporting resources, as shown here.

Report Center navigation links

1. Data Documents (Reports) — Document library to store a collection of documents.

2. Report Dashboards — Listing of all dashboards that you can configure.

3. Resources — Folder containing the following resources that can be used with Reporting Services reports:

  • Data Connections    Document library that contains shared data sources and/or report models that can be used among all reports.

  • Report Calendar    Calendar list that can contain any date-related information for a report or report schedule. For example, you can indicate on which dates report data is refreshed or loaded. This item has no specific integration points with Reporting Services.

  • Reference Library    Document library where you can store documents to help end users navigate and use the Report Center. This item has no specific integration points with Reporting Services.

After you, or your administrator, have successfully set up the integration between Reporting Services and Office SharePoint Server 2007, you can create and deploy reports to the server running Office SharePoint Server 2007.

Note: Before you can create your own reports, a developer, or your administrator, must first publish a Report Model to Office SharePoint Server 2007. A Report Model defines the data source for the report, security parameters for the data source, tables, fields, and relationships for how data is presented in a report.

To learn more about how Reporting Services and SharePoint products and technologies work together to help you create and deploy reports, see Reporting Services and SharePoint Technology Integration.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×