Skip to content

reporting-services-report-server-sharepoint-mode.md

Latest commit

 

History

History
149 lines (86 loc) · 14.9 KB

reporting-services-report-server-sharepoint-mode.md

File metadata and controls

149 lines (86 loc) · 14.9 KB
title Reporting Services Report Server (SharePoint Mode) | Microsoft Docs
ms.prod sql-server-2014
ms.technology reporting-services-native
ms.topic conceptual
author maggiesMSFT
ms.author maggies
manager kfile
ms.reviewer
ms.custom
ms.date 06/13/2017

Reporting Services Report Server (SharePoint Mode)

A [!INCLUDEssRSnoversion] report server configured for SharePoint Mode can run within a deployment of a SharePoint product. A report server in SharePoint mode can use the collaboration and management features of SharePoint for reports and other [!INCLUDEssRSnoversion] content types. SharePoint mode requires installing the appropriate version of the [!INCLUDEssRSnoversion] add-in for SharePoint products on your SharePoint Web Front Ends.

For more information on installing and configuring, see the following:

For information on what's new in this release, see the 'SharePoint' section in What's New (Reporting Services).

In this topic:

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, including alerts. A SharePoint site provides a unified portal for accessing and managing all report items 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 [!INCLUDEssNoVersion].

  • 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 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.

  • Microsoft Access services reporting, in connected mode.

  • AAM zones, internet facing deployments, and SharePoint user tokens for SharePoint lists.

Connected Mode and Local Mode

The SQL Server 2008 R2 release introduced a new local mode for viewing reports from a SharePoint 2010 server that has the Microsoft SQL Server 2008 R2 or later Reporting Services Add-In for SharePoint 2010 products installed.

Unsupported SharePoint Features

Not all SharePoint features are available for integrated operations. The following is a list of the SharePoint features [!INCLUDEssRSnoversion] does not directly integrate with:

  • Secure Store Service.

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

  • SharePoint Business Data catalog.

  • SharePoint personalization is also not supported on the [!INCLUDEssRSnoversion] pages. Report Server integration is not supported if the SharePoint Web application is enabled for Anonymous access.

  • SQL Server Reporting Services does not support SharePoint document library version control. If you save report items in a document library that is configured with "Document Version History" enabled, Reporting Services features will not function correctly and generate errors in the ULS log. The following is an example of an error in the ULS log:

    • "...a data source associated with the report has been disabled".

    Document library version history is configured on the "Versioning Settings" page of "Library Settings".

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. For more information, see Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2014)

Note

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

Components That Provide Integration

To combine the servers in a single deployment, you integrate an installation of [!INCLUDEssNoVersion] [!INCLUDEssRSnoversion] with an instance of SharePoint products

Integration is provided through [!INCLUDEssNoVersion] and the [!INCLUDEssRSnoversion] Add-in for SharePoint Products. The [!INCLUDEssRSnoversion] Add-in is a freely distributable component that you can download and then install on a server that is running the appropriate version of SharePoint.

Tip

Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. For more information see, Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2014).

  • On SharePoint, the [!INCLUDEssRSnoversion] Add-in provides the ReportServer proxy endpoint, a Report Viewer Web part, and application pages so that you can view, store, and manage report server content on a SharePoint site or farm.

  • On [!INCLUDEssRSnoversion] provides updated program files, a SOAP endpoint, and custom security and delivery extensions. The report server must be configured to run in SharePoint integrated mode, dedicated exclusively to supporting report access and delivery through your SharePoint site.

After you install the [!INCLUDEssRSnoversion] Add-in on SharePoint 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. Uploading or publishing report server content is an important first step; the Web Part and pages become available when you select report definitions (.rdl), report models (.smdl) and shared data sources (.rsds) on a SharePoint site.

Language Considerations

[!INCLUDESPF2010] and [!INCLUDESPS2010] products are available in many more languages than [!INCLUDEssNoVersion]

When you configure a report server to run within a deployment of a SharePoint product, you might see a combination of languages. The user interface, documentation, and messages will appear in the following languages:

  • All application pages, tools, errors, warnings, and messages that originate from [!INCLUDEssRSnoversion] will appear in the language used by the [!INCLUDEssRSnoversion] instance in one of the [!INCLUDEssNoVersion] languages.

  • Application pages that you open on a SharePoint site, the Report Viewer Web Part, and Report Builder will appear in one of the supported languages for the [!INCLUDEssRSnoversion] Add-in. To view the list of supported languages, go to SQL Server Downloads and find the download page for the [!INCLUDEssCurrent] [!INCLUDEssRSnoversion] Add-in.

  • SharePoint sites, SharePoint Central Administration, online help, and messages are available in the languages supported by Office Server products.

If the language of your SharePoint product or technology differs from the report server language, [!INCLUDEssRSnoversion] will try to use a language from the same language family that provides the closest match. If a close substitute is not available, the report server uses English.

Related Tasks

The following table summarizes tasks related to a [!INCLUDEssRSnoversion] SharePoint mode report server:

Task Link
Detailed steps for installing and configuring [!INCLUDEssRSnoversion] in SharePoint mode. Install Reporting Services SharePoint Mode for SharePoint 2010 and Add an Additional Report Server to a Farm (SSRS Scale-out).
Scale-out your [!INCLUDEssRSnoversion] SharePoint deployment by adding additional report servers. Add an Additional Report Server to a Farm (SSRS Scale-out) and Deployment Topologies for SQL Server BI Features in SharePoint .
Add additional SharePoint web front-ends that have the [!INCLUDEssRSnoversion] components installed for viewing and report items. Add an Additional Reporting Services Web Front-end to a Farm
Configure e-mail for [!INCLUDEssRSnoversion] data alerting and subscription features. Configure E-mail for a Reporting Services Service Application (SharePoint 2010 and SharePoint 2013)
Recent information for this release, found on the TechNet Wiki. SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting.

See Also

Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013) Hardware and Software Requirements for Reporting Services in SharePoint Mode Report Viewer Web Part on a SharePoint Site