Microsoft SQL Server 2008 R2 Reporting Services is a server-based reporting platform for creating and running reports that contain data from relational and multidimensional data sources. By installing the Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint 2010 Products, you can integrate a Reporting Services report server with SharePoint products. You can use the document management and collaboration features of SharePoint to simplify how you share, secure, manage, and use reports throughout your organization.
In This article
The new Reporting Services add-in, when combined with SQL Server 2008 R2 reporting services, adds support for new features including multiple SharePoint zones, supporrt of right -to-left Arabic and Hebrew character sets and support for the Unified Logging Service (ULS). These features require the integration of SharePoint 2010 with a Report Server instance in SharePoint integrated mode.
With this add-in alone Microsoft Access users can render reports without a SharePoint connection to a Report Server instance in SharePoint integrated mode. This is also called "local" mode. For information on these topics and others, review What's New with SharePoint Integration
Help and assistance with SQL Srever 2008 R2 Reporting Services can be found in online documentation as well as from an active user community. The online content contains tutorials and 'how to' topics on planning and operations. For information on these topics and others, review Getting Assistance (Reporting Services in SharePoint Integrated Mode)
For assistance with planning, security, and deployment, review Reporting Services with SharePoint Integration
Getting Started Designing a Report
Reporting Services supports using more than one report authoring application for creating and publishing reports to your SharePoint environment. For assistance using the stand-alone report design application, see Getting Started with Report Builder 3.0. To use the Business Intelligence Development Studio based report designer, see Designing and Implementing Reports Using Report Designer