Reporting Services 報表伺服器 (SharePoint 模式)Reporting Services Report Server (SharePoint Mode)

適用於:APPLIES TO: 是SQL Server Reporting Services (2016)SQL Server Reporting Services (2016) 是SharePointSharePoint 否Power BI 報表伺服器Power BI Report Server是SQL Server Reporting Services (2016)SQL Server Reporting Services (2016) 是SharePointSharePoint 否Power BI 報表伺服器Power BI Report Server

如需舊版 SQL Server Reporting Services (SSRS) 的相關內容,請參閱 SQL Server 2014 Reporting ServicesFor content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

SharePoint 模式設定的 Reporting Services 報表伺服器可以在 SharePoint 產品部署內執行。A Reporting Services report server configured for SharePoint Mode can run within a deployment of a SharePoint product. SharePoint 模式的報表伺服器可以針對報表和其他 Reporting ServicesReporting Services 內容類型使用 SharePoint 的共同作業和管理功能。A report server in SharePoint mode can use the collaboration and management features of SharePoint for reports and other Reporting ServicesReporting Services content types. SharePoint 模式需要在 SharePoint Web 前端安裝適用於 SharePoint 產品的正確 Reporting Services 增益集版本。SharePoint mode requires installing the appropriate version of the Reporting Services add-in for SharePoint products on your SharePoint Web Front Ends.


SQL Server 2016 後即不再提供 Reporting Services 與 SharePoint 的整合。Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

如需有關安裝及設定的詳細資訊,請參閱以下主題:For more information on installing and configuring, see the following:

功能摘要Feature summary

將報表伺服器設定為以 SharePoint 整合模式執行會提供下列的額外功能;只有在以此模式部署報表伺服器時,才能使用這些功能: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:

  • 使用 SharePoint 文件管理和共同作業功能,包括警示。Use SharePoint document management and collaboration features, including alerts. SharePoint 網站會提供統一入口網站,用於在單一位置存取和管理所有報表項目。A SharePoint site provides a unified portal for accessing and managing all report items in one place.

  • 使用 SharePoint 權限和驗證提供者來控制對報表、模型和其他項目的存取。Use SharePoint permissions and authentication providers to control access to reports, models, and other items.

  • 使用 SharePoint 部署拓撲將報表透過網際網路連接散發到防火牆以外。Use SharePoint deployment topologies to distribute reports over an Internet connection outside the firewall. 報表伺服器會以針對網際網路存取所設定的較大 SharePoint 部署內容提供報表和資料處理服務。A report server provides report and data processing services in the context of a larger SharePoint deployment that is configured for Internet access.

  • 在 SharePoint 網站的自訂應用程式頁面中管理報表、模型、資料來源、排程和報表記錄。Manage reports, models, data sources, schedules, and report history in custom application pages on a SharePoint site. 您可以在 SharePoint 網站上設定屬性、定義排程和訂閱並且建立與管理報表記錄,其方法與使用 SQL ServerSQL Server的其他工具來建立及管理這些項目時相同。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 ServerSQL Server.

  • 將報表、報表模型、資源和共用資料來源檔發行或上傳到 SharePoint 文件庫,包括 Office SharePoint Server 中的 Report Center。Publish or upload reports, report models, resources, and shared data source files to a SharePoint library, including Report Center in Office SharePoint Server.

    使用報表設計師、模型設計師與報表產生器來建立要直接發行至 SharePoint 文件庫的報表和資料來源。Use Report Designer, Model Designer, and Report Builder to create reports and data sources to be published directly to a SharePoint library. 您也可以在 SharePoint 網站上使用「上傳」動作,將所有的報表定義和報表模型加入至 SharePoint 程式庫。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. 任何能夠在原生模式報表伺服器中執行的報表,也都可以在設定為 SharePoint 整合模式的報表伺服器上執行。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.

  • 使用新的 SharePoint 傳遞延伸模組向 SharePoint 程式庫訂閱報表並將報表傳遞至 SharePoint 程式庫。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.

  • 您可以新增至 SharePoint 頁面以檢視 SharePoint Web 應用程式中之報表的報表檢視器 Web 組件。A Report Viewer web part you can add to SharePoint pages to view a report inside your SharePoint web application. Web 組件包含頁面導覽、搜尋、列印和匯出功能。The web part includes page navigation, search, print, and export features.

  • 根據新的 SOAP 端點進行程式設計,以建立能夠與 SharePoint 網站整合的自訂應用程式。Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site. 您也可以使用更新的 Windows Management Instrumentation (WMI) 提供者,以程式設計的方式設定以 SharePoint 整合模式執行的報表伺服器執行個體。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 服務報告。Microsoft Access services reporting, in connected mode.

  • AAM 區域、網際網路部署,以及 SharePoint 清單的 SharePoint 使用者 Token。AAM zones, internet facing deployments, and SharePoint user tokens for SharePoint lists.

連線模式與本機模式Connected mode and local mode

SQL Server 2008 R2 版本導入了全新的 「本機模式」 (Local Mode),可用於從已安裝適用於 SharePoint 2010 產品之 Microsoft SQL Server 2008 R2 或更新版的 Reporting Services 增益集的 SharePoint 2010 伺服器檢視報表。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.

  • 「本機模式」 :本機模式可讓您從 SharePoint 文件庫本機轉譯報表,而不需要與 Reporting Services 報表伺服器整合。Local Mode: Local mode allows reports to be rendered locally from the SharePoint document library, without integration with a Reporting Services report server. 需要 SharePoint 產品的 Reporting Services 增益集,但不需要 Reporting Services 報表伺服器。The Reporting Services add-in for SharePoint products is required but a Reporting Services report server is not. 增益集可以利用幾種不同的方式安裝,包括 SharePoint 2010 產品準備工具。The add-in can be installed several different ways, including the SharePoint 2010 products preparation tool. 如需本機模式的詳細資訊,請參閱比較報表檢視器中的本機模式與連線模式報表 (SharePoint 模式的 Reporting Services)尋找適用於 SharePoint 產品之 Reporting Services 增益集的位置For more information on local mode, see Local mode vs. connected mode reports in the Report Viewer and Where to find the Reporting Services add-in for SharePoint products.

  • 「連線模式」 :連線模式的支援方式是使用 SharePoint 管理中心,將 Reporting Services 報表伺服器整合至 SharePoint 伺服陣列中。Connected Mode: Connected mode is supported by integrating a Reporting Services report server into the SharePoint farm using SharePoint Central Administration. 與報表伺服器整合會啟用完整的端對端報表,並提供 SharePoint 2010 的共同作業功能以及報表伺服器的伺服器架構功能,包括:訂閱、快照集和伺服器架構處理。The integration with a report server enables full end-to-end reporting, providing the collaboration features of SharePoint 2010 and the server based features of a report server including: Subscriptions, Snapshots, and server based processing.

不支援的 SharePoint 功能Unsupported sharePoint features

並非所有 SharePoint 功能都可供整合作業使用。Not all SharePoint features are available for integrated operations. 以下是 Reporting Services 不會直接整合的 SharePoint 功能清單:The following is a list of the SharePoint features Reporting Services does not directly integrate with:

  • Secure Store Service。Secure Store Service.

  • 您無法在文件庫中針對 Reporting Services 檔案使用 SharePoint Outlook 行事曆整合或 SharePoint 排程。You cannot use the SharePoint Outlook Calendar integration or the SharePoint scheduling for reporting services files in a document library.

  • SharePoint 商務資料目錄。SharePoint Business Data catalog.

  • 在 Reporting Services 頁面上也不支援 SharePoint 個人化。SharePoint personalization is also not supported on the Reporting Services pages. 如果針對匿名存取啟用 SharePoint Web 應用程式,則不支援報表伺服器整合。Report Server integration is not supported if the SharePoint Web application is enabled for Anonymous access.

  • SQL Server Reporting Services 支援 SharePoint 文件庫版本控制。SQL Server Reporting Services does not support SharePoint document library version control. 如果您將報表項目儲存在已啟用「文件版本歷程記錄」設定的文件庫中,則 Reporting Services 功能將無法正確運作,而且會在 ULS 記錄中產生錯誤。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. 下列是 ULS 記錄中錯誤的範例: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".

支援的 SharePoint 增益集與報表伺服器組合Supported combinations of the SharePoint add-in and report server

在報表伺服器、適用 SharePoint 之 Reporting Services 增益集,以及 SharePoint 產品的所有組合中,並不支援所有功能。Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. 如需詳細資訊,請參閱支援的 SharePoint 和 Reporting Services 伺服器與增益集組合For more information, see Supported combinations of SharePoint and Reporting Services Server and add-in


正確版本的 Reporting Services 增益集必須搭配對應版本的 SharePoint 產品使用。The correct version of the Reporting Services add-in must be used with the corresponding version of SharePoint Products.

提供整合的元件Components that provide integration

若要將伺服器結合在單一部署內,可以將 SQL ServerSQL Server Reporting Services 的安裝與 SharePoint 產品的執行個體相整合To combine the servers in a single deployment, you integrate an installation of SQL ServerSQL Server Reporting Services with an instance of SharePoint products

整合是透過 SQL ServerSQL Server 和適用 SharePoint 產品的 Reporting Services 增益集所提供。Integration is provided through SQL ServerSQL Server and the Reporting Services Add-in for SharePoint Products. Reporting Services 增益集是可免費轉散發的元件,您可以下載並安裝在執行正確版本之 SharePoint 的伺服器上。The Reporting Services 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.


在報表伺服器、適用 SharePoint 之 Reporting Services 增益集,以及 SharePoint 產品的所有組合中,並不支援所有功能。Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. 如需詳細資訊,請參閱支援的 SharePoint 和 Reporting Services 伺服器與增益集組合For more information see, Supported combinations of SharePoint and Reporting Services Server and add-in.

  • Reporting Services 增益集可以在 SharePoint 上提供 ReportServer Proxy 端點、報表檢視器 Web 組件以及應用程式頁面,使您能夠在 SharePoint 網站或伺服陣列上檢視、儲存和管理報表伺服器內容。On SharePoint, the Reporting Services 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.

  • 在 Reporting Services 上提供了更新的程式檔、SOAP 端點及自訂安全性和傳遞延伸模組。On Reporting Services provides updated program files, a SOAP endpoint, and custom security and delivery extensions. 報表伺服器必須設定為以 SharePoint 整合模式執行,且專門支援透過 SharePoint 網站來存取及傳遞報表。The report server must be configured to run in SharePoint integrated mode, dedicated exclusively to supporting report access and delivery through your SharePoint site.

在 SharePoint 上安裝 Reporting Services 增益集並將這兩個伺服器設定整合之後,您就可以將報表伺服器內容類型上傳或發行至 SharePoint 文件庫,然後從 SharePoint 網站檢視和管理這些文件。After you install the Reporting Services 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. 上傳或發行報表伺服器內容是第一個重要步驟;當您在 SharePoint 網站上選取報表定義 (.rdl)、報表模型 (.smdl) 和共用資料來源 (.rsds) 時,Web 組件和網頁就會變成可以使用。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

SharePoint Foundation 2010SharePoint Foundation 2010 >及< SharePoint Server 2010SharePoint Server 2010 產品所提供的語言比 SQL ServerSQL Serverand SharePoint Server 2010SharePoint Server 2010 products are available in many more languages than SQL ServerSQL Server

將報表伺服器設定為在 SharePoint 產品的部署內執行時,可能會看到多種語言。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:

  • 所有源自 SQL ServerSQL Server 的應用程式頁面、工具、錯誤、警告和訊息,都會由 Reporting Services 執行個體所使用的語言以其中一種 Reporting Services 語言來顯示。All application pages, tools, errors, warnings, and messages that originate from Reporting Services will appear in the language used by the Reporting Services instance in one of the SQL ServerSQL Server languages.

  • 您在 SharePoint 網站、報表檢視器 Web 組件與報表產生器上開啟的應用程式頁面將會以 Reporting Services 增益集的其中一種支援語言來顯示。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 Reporting Services Add-in. 若要檢視支援語言的清單,請移至 SQL Server 下載區,然後尋找 SQL Server 2016 Reporting Services 增益集的下載頁面。To view the list of supported languages, go to SQL Server downloads and find the download page for the SQL Server 2016 Reporting Services Add-in.

  • SharePoint 網站、SharePoint 管理中心、線上說明和訊息會以 Office Server 產品所支援的語言提供。SharePoint sites, SharePoint Central Administration, online help, and messages are available in the languages supported by Office Server products.

如果 SharePoint 產品或技術的語言與報表伺服器語言不同,則 Reporting Services 會嘗試使用相同語系中最接近的語言。If the language of your SharePoint product or technology differs from the report server language, Reporting Services 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.

下表摘要說明與 Reporting Services SharePoint 模式報表伺服器相關的工作:The following table summarizes tasks related to a Reporting Services SharePoint mode report server:

工作Task 連結Link
安裝和設定 SharePoint 模式之 Reporting Services 的詳細步驟。Detailed steps for installing and configuring Reporting Services in SharePoint mode. 安裝適用於 SharePoint 2010 的 Reporting Services SharePoint 模式將其他報表伺服器新增至伺服器陣列Install Reporting Services SharePoint mode for SharePoint 2010 and Add an additional Report Server to a farm.
新增額外的報表伺服器,藉以向外延展您的 Reporting Services SharePoint 部署。Scale-out your Reporting Services SharePoint deployment by adding additional report servers. 將其他報表伺服器新增至伺服器陣列SharePoint 中 SQL Server BI 功能的部署拓撲Add an additional Report Server to a Farm and Deployment topologies for SQL Server BI features in SharePoint.
新增針對檢視和報表項目安裝之 Reporting Services 元件的其他 SharePoint Web 前端。Add additional SharePoint web front-ends that have the Reporting Services components installed for viewing and report items. 將其他 Reporting Services Web 前端新增至伺服器陣列Add an additional Reporting Services web front-end to a farm
在 SharePoint 內設定報表伺服器的電子郵件。Configure e-mail for your report server within SharePoint. 設定 Reporting Services 服務應用程式的電子郵件Configure e-mail for a Reporting Services service application
此版本的最新資訊位於 TechNet Wiki 上。Recent information for this release, found on the TechNet Wiki. SQL Server 2012 Reporting Services 提示、祕訣和疑難排解SQL Server 2012 Reporting Services tips, tricks, and troubleshooting.

後續步驟Next steps

安裝或解除安裝適用於 SharePoint 的 Reporting Services 增益集 SharePoint 網站上的報表檢視器 Web 組件Install or uninstall the Reporting Services sdd-in for SharePoint Report Viewer web part on a SharePoint site

更多問題嗎?More questions? 請嘗試詢問 Reporting Services 論壇Try asking the Reporting Services forum