Share via

What's New (Reporting Services in SharePoint Integrated Mode)

This latest release of Reporting Services introduces new features and enhancements for an Reporting Services environment that is integrated with a SharePoint product. The features fall into two broad categories of features related to a report server configured for SharePoint integration mode and features related to the SQL Server 2008 R2 Reporting Services Add-in for SharePoint products. Some apply to both.

For information about new features and enhancements available for a native mode deployment of Reporting Services, see What's New (Reporting Services).

Support for Multiple SharePoint Zones

In previous releases of Reporting Services, report server items were available from only the default SharePoint zone, which restricted the ability to access such items from other SharePoint zones. In this latest release of Reporting Services, you can use the alternate access mapping functionality in your SharePoint environment to access report server items from one or more of the following SharePoint zones: default, Internet, intranet, extranet, or custom. This is useful when you have a SharePoint environment that can be accessed by users from multiple zones. For example, your SharePoint site might be available to users from the Internet and an intranet. By using alternate access mapping, you can ensure that users from the Internet and intranet zones can access the same report server items from your SharePoint site. For more information about alternate access mappings, see Plan alternate access mappings (Windows SharePoint Services) and Configure alternate access mapping (Windows SharePoint Services) in the Windows SharePoint Services TechNet library.

Support for SharePoint User Token

Reporting Services introduced a new server interface called IRSSetUserToken. When this interface is implemented, the report server calls the UserToken Set property on this interface and passes the SharePoint user token to the data extension. If you have data stored in a SharePoint site, you can use the SharePoint user token to connect to a SharePoint site by using the SharePoint Object Model, and then retrieve data from the site by using SharePoint credentials.

Scripting with the rs utility

The rs utility now supports servers configured in SharePoint integrated mode. Use this utility to automate deployment and administration tasks. For more information on using the rs utility, see Scripting with the rs Utility and the Web Service and rs Utility

Claims Based Authentication

SQL Server 2008 R2 Reporting Services in SharePoint integrated mode, supports SharePoint Claims based authentication as well as the existing SharePoint User Tokens. For more information, see Claims Authentication and Reporting Services.

This section applies to the SQL Server 2008 R2 Reporting Services Add-in for SharePoint products. It is highly recommended you use the SQL Server 2008 R2 version of the add-in with a SQL Server 2008 R2 report server for maximum benefits.

Easier configuration

The new add-in makes it easier to configure SharePoint server for integration to a Reporting Services report server with a reduced number of steps from the previous add-in.

For more information, see How to: Configure Report Server Integration in SharePoint Central Administration

Getting Data from a SharePoint List

Your can now use data from a SharePoint list as a data source to for reports. There is a new Microsoft SharePoint List and query experience to allow you to easily bring SharePoint list information into your report. For more information, see SharePoint List Connection Type (SSRS)

Support for SharePoint Universal Logging Service

Reporting Services now provides several categories which can be configured to be a part of the SharePoint diagnostic logging. The new categories are part of the 'SQL Server Reporting Services' log file area and will log information ranging from user interface usage the SOAP client proxy. For more information, see Events for a Report Server in SharePoint Integrated Mode and How to: Turn on Reporting Services events for the SharePoint trace log (ULS)

Local Mode

Reports from Microsoft Access 2010 and the new Reporting Services SharePoint list data extension can run locally from the SharePoint document library, without a connection to a SQL Server reporting services report server. For more information, see Rendering Local Mode Reports in the Report Viewer (Reporting Services in SharePoint Integrated Mode)

Additional language and character support

The Reporting Services related user interface within SharePoint now supports 37 languages, Right to Left character sets with Hebrew and Arabic, and complex text layout with Thai. This support includes the report viewer web part as well as document library menus and user interface controls.

When working with reports on a SharePoint server integrated with reporting services, subscriptions and drill-through links will now work directly with the linked resources in the document library itself.

HTTP requests

An HTTP redirector which listens for requests from clients like report builder to the SharePoint web front end and will re-direct the requests to the report server