Features Supported by Reporting Services in SharePoint Integrated Mode

This topic provides a summary of the features that are available on a report server that is configured for integration with SharePoint. To learn more about integration requirements and how the server technologies work together, see Overview of Reporting Services and SharePoint Technology Integration and Requirements for Running Reporting Services in SharePoint Integrated Mode.

Feature Summary

Configuring a report server to run in SharePoint integrated mode provides the following additional functionality that is only available when you deploy a report server in this mode:

  • Use SharePoint document management and collaboration features. A SharePoint site provides a unified portal for accessing and managing all documents in one place.

  • Use SharePoint permissions and authentication providers to control access to reports, models, and other items.

  • Use SharePoint deployment topologies to distribute reports over an Internet connection outside the firewall. A report server provides report and data processing services in the context of a larger SharePoint deployment that is configured for Internet access.

  • Manage reports, models, data sources, schedules, and report history in custom application pages on a SharePoint site. You can set properties, define schedules and subscriptions, and create and manage report history on a SharePoint site the same way you create and manage them from other tools in SQL Server.

  • Publish or upload reports, report models, resources, and shared data source files to a SharePoint library, including Report Center in Office SharePoint Server.

    Use Report Designer, Model Designer, and Report Builder 3.0 to create reports and data sources to be published directly to a SharePoint library. You can also use the Upload action on a SharePoint site to add any report definitions and report models to a SharePoint library.

    Because the report server processes report definitions in the same way regardless of the server mode you use, the report data and layout is unaffected by server mode. Any report that you can run in a native mode report server can run on a report server that is configured for SharePoint integrated mode.

  • Subscribe to and deliver reports to a SharePoint library using a new SharePoint delivery extension. You can also deliver reports through e-mail or to a shared folder. The report server delivery extensions are used to deliver reports. You can create data-driven subscriptions for large-scale report distribution using subscriber data queried at run time.

  • A Report Viewer Web Part you can add to SharePoint pages to view a report inside your SharePoint web application. The Web Part includes page navigation, search, print, and export features.

  • Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site. You can also use the updated Windows Management Instrumentation (WMI) provider to programmatically configure a report server instance that runs in SharePoint integrated mode.

Features that behave differently in SharePoint integrated mode

The following features behave differently on a report server that is configured for SharePoint integrated mode when compared to a report server in native mode:

  • URL addressing is different in SharePoint integrated mode. SharePoint URLs are used to reference reports, report models, shared data sources, and resources. The report server folder hierarchy is not used. If you have custom applications that rely on URL access as supported on a native mode report server, that functionality will no longer work when the report server is configured for SharePoint integration.

  • For more information on URL access, see Using URL Access Parameters

Unsupported SharePoint Features

Not all features are available for integrated operations. The following is a list of some of the SharePoint features Reporting Services does not directly integrate with:

  • You cannot use the SharePoint Outlook Calendar integration or the SharePoint scheduling for reporting services files in a document library.

  • SharePoint personalization is also not supported on the Reporting Services pages. Report Server integration is not supported if the SharePoint Web application is enabled for Anonymous access.

Unsupported Reporting Services Features

The following features are not available on a report server that runs in SharePoint integrated mode:

  • Reporting Services custom security extensions cannot be deployed or used on the report server. The report server includes a special-purpose security extension that is used whenever you configure a report server to run in SharePoint integrated mode. This security extension is an internal component, and it is required for integrated operations.

  • Report Manager cannot be used to manage a report server instance that is configured for SharePoint integration.

  • Linked reports are not supported.

  • My Reports is not supported.

  • My Subscriptions

  • Batching methods are not supported.

Supported combinations of the SharePoint add-in and Report Server

Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. The recommended and most complete combination is to use SharePoint 2010 Products, the SQL Server 2008 R2 Reporting Services add-in for SharePoint 2010 Products, and SQL Server 2008 R2 report server in SharePoint Integrated mode.

Note

The correct version of the Reporting Services add-in must be used with the corresponding version of SharePoint Products.

SharePoint 2010 Products with the SQL Server 2008 R2 Reporting Services add-in for SharePoint 2010 Products

The following table summarizes the new features that are added by the server or noted version of the add-in.

Features the 2008 R2 Report Server provides

Features the 2008 R2 Add-in provides to the SharePoint experience

  • Support for Multiple SharePoint Zones.

  • Rs.exe utility supports scripting with servers in SharePoint Integrated mode.

  • Report Builder 3.0 Support.

  • Data extension (connected mode only) and query designer for SharePoint Lists as data sources.

  • Atom Rendering Extension.

  • Support using Trusted Account authentication for SharePoint web applications using login.

  • Report Parts.

  • 2010 management endpoint.

  • Microsoft Access reporting in connected mode when Access Services is enabled.

  • Installing for SharePoint 2010 products only.

  • New web pages to manage Report Parts.

  • Atom Renderer specific icon in the ReportViewer web part toolbar.

  • Improved Report Preview experience with Report Builder 3.0 and edit sessions.

  • 2010 End Point Proxy.

  • One Step configuration of the add-in.

  • Support for SharePoint ULS Logging.

  • Local Mode for viewing reports with SharePoint List data extension.

  • Access Reporting in local mode when Access Services is enabled.

  • Installation of the add-in as a pre-requisite before SharePoint.

  • 37 languages supported including bi-directional languages (Hebrew and Arabic) and complex script languages Reporting Services web pages.

The current version of the add-in for SharePoint 2010 products can be down loaded from the Microsoft Download Center.

For more information on the new features, See What's New (Reporting Services in SharePoint Integrated Mode)

SharePoint 2010 Products with SQL Server 2008 SP1 CU#8

It is possible to use SharePoint 2010 Products with a SQL Server 2008 report server if the server has been updated to SQL Server 2008 Service Pack 1 and Cumulative update package 8 for SP1. The features that are supported in this configuration are those areas of SharePoint 2010 that are backwards compatible with SharePoint 2007, such as Windows Legacy authentication. Features that are new to SharePoint 2010 will not be supported. For example Claims authentication.

For more information see SQL Server 2008 SP1 Cumulative update package 8.

SharePoint 2007 Technologies with the SQL Server 2008 SP2 Reporting Services Add-in for SharePoint 2007 Technologies

The following table summarizes the new features that are added by the server or noted version of the add-in.

Features the SQL Server 2008 R2 Report Server provides

Features the updated SQL Server 2008 Add-in adds to the existing SharePoint experience

  • Support for Multiple SharePoint Zones.

  • Rs.exe utility supports scripting with servers in SharePoint Integrated mode.

  • Report Builder 3.0 Support.

  • Data extension (connected mode only) and query designer for SharePoint Lists as data sources.

  • Atom Rendering Extension.

  • Report Parts

  • 2010 management endpoint.

  • New web pages to manage Report Parts.

  • Atom Renderer specific icon in the ReportViewer web part toolbar.

  • Improved Report Preview experience with Report Builder 3.0 and edit sessions.

  • 2010 End Point Proxy

The current version of the add-in for 2007 products can be downloaded from the Microsoft Download Center.