Documentation for SSRS reports in SharePoint (overview)
Published: May 8, 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.
Deployment Topologies for Reporting Services in SharePoint Integrated Mode Describes different deployment scenarios and what is supported for integration between SharePoint 2010 Products and Reporting Services.
Requirements for Running Reporting Services in SharePoint Integrated Mode Specifies edition and software requirements.
Storing and Synchronizing Report Server Content With SharePoint Databases Shows how the SharePoint configuration and content databases synchronize with the report server database to store content and metadata.
How Do I Learn About SharePoint Integrated Mode Provides a roadmap for SQL Server 2008 Reporting Services integration with Office SharePoint Server 2007. The roadmap includes multiple articles about planning and architecture, installation and configuration, Web Parts, programmability for SharePoint integrated mode, and more.
Configuration for Reporting Services in SharePoint integrated mode
The following articles describe steps to configure Reporting Services in SharePoint integrated mode.
Configuring Reporting Services for SharePoint 2010 Integration Gives the step-by-step instructions for deployment and configuration scenarios for Reporting Services for SharePoint 2010 integration. Several "how-to" articles follow.
Default Configuration for SharePoint Integrated Mode (Reporting Services) Refers to a Reporting Services installation where Setup installs and configures a report server instance and creates the report server database in a format that supports content storage.