Documentation for SSRS reports in SharePoint (overview)


Applies to: SharePoint Server 2010

Microsoft SQL Server 2008 Reporting Services (SSRS) is a server-based reporting platform that provides a full range of ready-to-use tools and services to help you create, deploy, and manage Reporting Services reports for your organization. This article gives an overview of SQL Server Reporting Services in SharePoint integrated mode and has links to articles in SQL Server Books Online to help you plan and configure. After you install the Reporting Services Add-in on Microsoft SharePoint Server and configure the two servers for integration, you can upload or publish report server content types to a SharePoint library and then view and manage those documents from a SharePoint site.

Reporting Services deploys in the following two modes.

  • Native mode describes a report server that runs as an application server alone, without sharing the content database with SharePoint Server. Reports can be managed and viewed through the Report Manager Web application. SharePoint Web Parts can be enabled so you can select and view reports from a report server.

  • SharePoint integrated mode means that a report server is integrated with a SharePoint Server farm and requires you to configure the report server in integrated mode and that you download and configure an add-in component on each of your SharePoint front-end Webs. Integrated mode allows the user to manage and view reports from SharePoint document libraries.

Overview of Reporting Services in SharePoint integrated mode

The following articles describe improvements to SQL Server 2008 that relate to business intelligence.

  • What's New (Reporting Services in SharePoint Integrated Mode)   Discusses new features in Reporting Services and improvements for the Reporting Services environment that is integrated with a SharePoint product. The new features include support for multiple SharePoint Zones, the SharePoint Universal Logging service, and Report Parts. There is also a new SharePoint List data extension that has query designer support.

  • Overview of Reporting Services and SharePoint Technology Integration   Explains that when you integrate a report server that uses an instance of one of the Microsoft SharePoint 2010 Products, items and properties are stored in the SharePoint content databases. The article provides a description of the databases that contain the content for the report server and SharePoint Server 2010.

Planning and architecture for Reporting Services in SharePoint integrated mode

The following articles describe SQL Server Reporting Services integration with SharePoint 2010 Products and how to plan an implementation.

Configuration for Reporting Services in SharePoint integrated mode

The following articles describe steps to configure Reporting Services in SharePoint integrated mode.

See Also

Other Resources

Resource Center: Business Intelligence in SharePoint Server 2010