SQL Server Reporting Services (SSRS) 中的新功能What's new in SQL Server Reporting Services (SSRS)

適用於:APPLIES TO: 是SQL Server 2016 Reporting Services 和更新版本SQL Server 2016 Reporting Services and later 否Power BI 報表伺服器Power BI Report Server是SQL Server 2016 Reporting Services 和更新版本SQL Server 2016 Reporting Services and later 否Power BI 報表伺服器Power BI Report Server

了解 SQL Server Reporting ServicesReporting Services 中的新功能。Learn about what's new in SQL Server Reporting ServicesReporting Services. 本文章涵蓋主要功能領域,並會在發行新的項目時更新。This article covers the major feature areas and is updated as new items are released.

如需取得目前的版本資訊,請參閱 SQL Server 2017 版本資訊For the current release notes, see SQL Server 2017 Release Notes.

如需 Power BI 報表伺服器的資訊,請參閱什麼是 Power BI 報表伺服器?For information about Power BI Report Server, see What is Power BI Report Server?.

下載 downloadDownload download

請前往 Microsoft 下載中心 下載 SQL Server 2017 Reporting Services。To download SQL Server 2017 Reporting Services, go to the Microsoft Download Center.

SQL Server 2019 Preview Reporting ServicesSQL Server 2019 preview Reporting Services

SQL Server 2019 預覽SQL Server 2019 preview Reporting Services 不適用於 CTP 3.1。Reporting Services isn't available for CTP 3.1. 安裝目前的版本 SQL Server 2017 Reporting ServicesInstall the current version, SQL Server 2017 Reporting Services.

SSRS 2017SSRS 2017

報表的註解Comments on reports

報表現在提供留言功能,可新增觀點並與其他人共同作業。Comments are now available for reports, to add perspective, and collaborate with others. 您也可以在留言內包含附件。You can also include attachments with comments.

報表伺服器內的註解

如需詳細資訊,請參閱新增報表伺服器中報表的註解For more information, see Add comments to a report in a report server.

報告工具中的 DAX 查詢DAX queries in reporting tools

在最新版本的報表產生器及 SQL Server Data Tools 中,您可對 SQL Server Analysis Services 表格式資料模型建立原生 DAX 查詢。In the latest releases of Report Builder and SQL Server Data Tools, you can create native DAX queries against the SQL Server Analysis Services tabular data models. 您可於查詢設計工具中拖放欄位。You can drag and drop fields in the query designers. 請參閱 Reporting Services 部落格See the Reporting Services blog.

REST API 支援REST API support

為了進行現代化應用程式的開發和自訂,SQL Server Reporting Services 現在支援完全符合 OpenAPI 的 RESTful API。To enable development of modern applications and customization, SQL Server Reporting Services now supports a fully OpenAPI compliant RESTful API. 您現在可以在 swaggerhub 上找到完整的 API 規格和文件。The full API specification and documentation can now be found on swaggerhub.

現在報表產生器及 SQL Server Data Tools 中支援 DAX 的查詢設計工具Query designer support for DAX now in Report Builder and SQL Server Data Tools

您現在可以在報表產生器及 SQL Server Data Tools 中,對支援的 SQL Server Analysis Services 表格式資料模型建立原生 DAX 查詢。In Report Builder and SQL Server Data Tools, you can now create native DAX queries against supported SQL Server Analysis Services tabular data models. 您可以在這兩個工具中使用查詢設計工具來拖放您想要的欄位。You can use the query designer in both tools to drag and drop the fields you want. DAX 查詢隨即會為您產生。The DAX query is then generated for you.

請參閱 Reporting Services 部落格Read more on the Reporting Services blog.

注意:您只能搭配使用 DAX 的查詢設計工具與 SQL Server 2016+ 內建的 SSAS 表格式資料來源。Note: You can only use the query designer for DAX with SSAS tabular data sources built in SQL Server 2016+.

SSRS 2016SSRS 2016

Reporting Services 入口網站web portalReporting Services 入口網站web portal

有新的 Reporting ServicesReporting Services 入口網站web portal 可用。A new Reporting ServicesReporting Services 入口網站web portal is available. 更新的入口網站包含The updated web portal includes

  • KPIKPIs
  • 行動報表Mobile Reports
  • 分頁的報表Paginated Reports
  • Excel 檔案Excel files
  • Power BI Desktop 檔案Power BI Desktop files

入口網站web portal 取代舊版中的報表管理員。The 入口網站web portal replaces Report Manager from previous releases.

若要建立行動報表,您需要 行動報表發行工具Mobile Report PublisherTo create Mobile Reports, you need the 行動報表發行工具Mobile Report Publisher.

如需 入口網站web portal的詳細資訊,請參閱 入口網站 (SSRS 原生模式)For more information about the 入口網站web portal, see Web portal (SSRS Native Mode).

ssRSPortalssRSPortal

入口網站web portal 的自訂商標Custom branding for the 入口網站web portal

您可以使用商標套件,以組織的標誌和色彩自訂 入口網站web portalYou can customize the 入口網站web portal with your organization's logo and colors by using a branding pack.

如需自訂商標的詳細資訊,請參閱 建立入口網站品牌形象For more information about custom branding, see Branding the web portal

入口網站web portal中的關鍵效能指標 (KPI)Key performance indicators (KPI) in the 入口網站web portal

您可以直接在 入口網站web portal 中,建立與目前資料夾內容相關的 KPI。You create KPIs directly in the 入口網站web portal that are contextual to the current folder. 建立 KPI 時,您可以選擇資料集欄位並彙總它們的值。When creating KPIs, you can choose dataset fields, and summarize their values. 您也可以選取相關內容,以鑽研至更多詳細資料。You can also select related content to drill-through to expose more details.

ssrs-webportal-kpi

如需詳細資訊,請參閱 使用入口網站中的 KPIFor more information, see Working with KPIs in the web portal

行動報表Mobile Reports

Reporting Services 行動報表是針對各種外形規格最佳化的專用報表,並為存取行動裝置上報表的使用者提供最佳體驗。Reporting Services mobile reports are dedicated reports optimized for a wide variety of form factors and provide an optimal experience for users accessing reports on mobile devices. 行動報表具備各種視覺效果,從時間、類別和比較圖表到矩形式樹狀結構圖和自訂的對應。Mobile reports feature an assortment of visualizations, from time, category, and comparison charts, to tree maps and custom maps. 將行動報表連接到資料來源範圍,包括內部部署 SQL Server Analysis Services 多維度和表格式資料。Connect your mobile reports to a range of data sources, including on-premises SQL Server Analysis Services multidimensional and tabular data. 您可在設計界面上為行動報表放置方格列和欄會調整的欄位。You can place fields for mobile reports on a design surface with adjusting grid rows and columns. 富彈性的行動報表元素會自動調整以符合任何畫面大小。The flexible mobile report elements automatically scale to fit any screen size. 您可以將行動報表儲存至報表服務伺服器,並在瀏覽器或 Power BI 行動應用程式中加以檢視和互動。You save the mobile reports to a Reporting Service server, and can view and interact with them in a browser, or the Power BI mobile app. 支援的裝置包括:Devices supported include:

  • iPadiPad
  • iPhoneiPhones
  • Android 手機Android phones
  • 或任何 Windows 10 裝置or any Windows 10 device

行動報表發行工具Mobile Report Publisher

SQL Server 行動報表發行工具SQL Server Mobile Report Publisher可讓您將 SQL Server 行動報表建立並發行到您的 Reporting ServicesReporting Services 入口網站web portalThe SQL Server 行動報表發行工具SQL Server Mobile Report Publisherallows you to create and publish SQL Server mobile reports to your Reporting ServicesReporting Services 入口網站web portal.

SS_MRP_LayoutTabSmallSS_MRP_LayoutTabSmall

如需詳細資訊,請參閱 使用 SQL Server 行動報表發行工具建立行動報表For more information, see Create mobile reports with SQL Server Mobile Report Publisher.

裝載於 Reporting Services 的 SQL Server 行動報表可在 Power BI Mobile 應用程式中使用SQL Server mobile reports hosted in Reporting Services available in Power BI Mobile app

iPad 和 iPhone 上適用於 iOS 的 Power BI 行動裝置應用程式現在可以顯示裝載於本機報表伺服器的 SQL Server 行動報表。The Power BI Mobile app for iOS on iPad and iPhone can now display SQL Server mobile reports hosted on your local report server.

SS_MRP_iPad_HomeSmSS_MRP_iPad_HomeSm

根據預設,您必須進行幾項組態變更才能連接。You can't connect by default without some configuration changes. 如需如何允許 Power BI Mobile 應用程式連接到報表伺服器的詳細資訊,請參閱 啟用報表伺服器進行 Power BI 行動存取For more information on how to allow the Power BI Mobile app to connect to your report server, see Enable a report server for Power BI Mobile access.

支援 SharePoint 模式和 SharePoint 2016 模式。Support of SharePoint mode and SharePoint 2016

SQL Server 2016 (13.x)SQL Server 2016 (13.x) Reporting ServicesReporting Services 支援與 SharePoint 2013 和 SharePoint 2016 整合。Reporting ServicesReporting Services supports integration with SharePoint 2013 and SharePoint 2016.

如需詳細資訊,請參閱:For more information, see:

Microsoft .NET Framework 4 支援Microsoft .NET Framework 4 Support

SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS) 支援 Microsoft .NET Framework 4 的目前版本,包含 4.0 和 4.5.1 版。supports the current versions of Microsoft .NET Framework 4, including version 4.0 and 4.5.1. 如果尚未安裝 .Net Framework 4.x 版本, SQL ServerSQL Server 安裝程式會在功能安裝步驟安裝 .NET 4.0。If a 4.x version of .Net Framework isn't already installed, SQL ServerSQL Server setup installs .NET 4.0 during the feature installation step.

報表改進Report improvements

HTML 5 轉譯引擎 :新的 HTML5 轉譯引擎以新式 Web「完整」標準模式及新式瀏覽器為目標。HTML 5 Rendering Engine: A new HTML5 rendering engine that targets modern web "full" standards mode and modern browsers. 新的轉譯引擎不再依賴幾種舊瀏覽器使用的 quirks 模式。The new rendering engine no longer relies on quirks mode used by a few older browsers.

如需瀏覽器支援的詳細資訊,請參閱 Reporting Services 和 Power View 的瀏覽器支援For more information on browser support, see Browser Support for Reporting Services and Power View.

新式編頁報表: 使用樣式新穎的圖表、量測計、地圖和其他資料視覺效果,設計美觀的新式編頁報表。Modern paginated reports: Design beautifully modern paginated reports with new, modern styles for charts, gauges, maps, and other data visualizations.

矩形式樹狀結構圖和放射環狀圖: 使用矩形式樹狀結構圖 ssrs_treemap_icon 和放射環狀圖 ssrs_sunburst_icon 增強報表,這是顯示階層式資料的不錯方式。Tree Map and Sunburst Charts: Enhance your reports with Tree Map ssrs_treemap_icon and Sunburst ssrs_sunburst_icon charts, great ways to display hierarchical data. 如需詳細資訊,請參閱 Tree Map and Sunburst Charts in Reporting ServicesFor more information, see Tree Map and Sunburst Charts in Reporting Services.

報表內嵌: 您現在可以使用 iframe 及 URL 參數,將行動和分頁報表內嵌到其他網頁和應用程式中。Report embedding: You can now embed mobile and paginated reports in other web pages, and applications by using an iframe, along with URL parameters.

將報表項目釘選到 Power BI 儀表板 :當您在 入口網站web portal中檢視報表時,可以選取報表項目,並將其釘選到 Power BIPower BI 儀表板。Pin Report Items to a Power BI Dashboard: While viewing a report in the 入口網站web portal, you can select report items and pin them to a Power BIPower BI dashboard. 可釘選的項目包括圖表、量測計面板、地圖和影像。The items you can pin are charts, gauge panels, maps, and images. 您可以:You can:

  1. 選取包含欲釘選之儀表板的群組。Select the group that contains the dashboard you want to pin to.
  2. 選取要將項目釘選至的儀表板。Select the dashboard you want to pin the item to.
  3. 選取您儀表板更新磚的頻率。Select how frequently you want the tile updated in the dashboard.

注意:重新整理由 Reporting ServicesReporting Services 訂用帳戶管理,而釘選項目之後,您可以編輯訂用帳戶和設定不同的重新整理排程。note The refresh is managed by Reporting ServicesReporting Services subscriptions and after the item is pinned, you can edit the subscription and configure a different refresh schedule.

ssRS_Pin_to_PowerBI

如需詳細資訊,請參閱 Power BI 報表伺服器整合 (設定管理員)將 Reporting Services 項目釘選到 Power BI 儀表板For more information, see Power BI Report Server Integration (Configuration Manager) and Pin Reporting Services items to Power BI Dashboards.

PowerPoint 轉譯及匯出 :Microsoft PowerPoint (PPTX) 格式是新的 SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS) 轉譯延伸模組。PowerPoint Rendering and Export: The Microsoft PowerPoint (PPTX) format is a new SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS) rendering extension. 您可以使用 PPTX 格式從下列常用應用程式匯出報表:報表產生器、報表設計師 (在 SSDT 中) 和 入口網站web portalYou can export reports in the PPTX format from the usual applications; Report Builder, Report Designer (in SSDT), and the 入口網站web portal. 如需範例,下圖顯示了 入口網站web portal 的匯出功能表。For the example, the following image shows the export menu from the 入口網站web portal.

ssrs-export-powerpoint

您也可以對訂閱輸出選取 PPTX 格式,並使用報表伺服器 URL 存取來轉譯及匯出報表。You can also select the PPTX format for subscription output and use Report Server URL access to render and export a report. 例如,您瀏覽器中的以下 URL 命令會從報表伺服器的具名執行個體匯出報表。For example, the following URL command in your browser exports a report from a named instance of the report server.

https://servername/ReportServer_THESQLINSTANCE/Pages/ReportViewer.aspx?%2freportfolder%2freport+name+with+spaces&rs:Format=pptx  

如需詳細資訊,請參閱 Export a Report Using URL AccessFor more information, see Export a Report Using URL Access.

PDF 於遠端列印取代了 ActiveX: 報表檢視器工具列現在會透過 PDF 列印,而非 ActiveX 控制項。PDF Replaces ActiveX for Remote Printing: The report viewer toolbar now prints Via PDF instead of ActiveX controls. 包含 Microsoft Edge 在內的大多數新式瀏覽器都支援新的報表檢視器。The new report viewer is supported by most modern browsers, including Microsoft Edge. 不再需要下載任何 ActiveX 控制項!No more ActiveX controls to download! 根據您使用的瀏覽器以及已安裝的 PDF 檢視應用程式和服務,Reporting ServicesReporting Services 或 [列印] 對話方塊會開啟以列印您的報表,或您會收到下載 .PDF 檔案的提示。Depending on the browser you use and the PDF viewing applications and services you've installed, Reporting ServicesReporting Services either a print dialog box opens to print your report, or you are prompted to download a .PDF file. 您身為系統管理員,仍然可以從 Management StudioManagement Studio 停用用戶端列印。As an administrator, you can still disable client-side printing from Management StudioManagement Studio.

如需詳細資訊,請參閱 啟用和停用 Reporting Services 的用戶端列印For more information, see Enable and Disable Client-Side Printing for Reporting Services.

ssrs-pdf-printing

訂閱功能改進Subscription Improvements

功能Feature 支援的伺服器模式Supported server mode
啟用和停用訂閱Enable and disable subscriptions. 新的使用者介面選項可快速停用及啟用訂閱。New user interface options to quickly disable and enable subscriptions. 停用的訂閱會維持其中的其他組態屬性,例如排程,並且可以輕鬆啟用。The disabled subscriptions maintain their other configuration properties such as schedule and can be easily enabled.

ssrs-enable-disable-subscriptionsssrs-enable-disable-subscriptions

如需詳細資訊,請參閱 Disable or Pause Report and Subscription ProcessingFor more information, see Disable or Pause Report and Subscription Processing.
原生模式Native mode
訂閱描述Subscription description. 您現在可以在建立新訂閱時,在訂閱屬性中加入報表的描述。When you create a new subscription, you can now include a description of the report as part of the subscription properties. 該描述會加到訂閱摘要頁面上。The description is included on the subscription summary page. SharePoint 與原生模式SharePoint and Native mode
變更訂閱擁有者Change subscription owner. 加強的使用者介面可快速變更訂閱的擁有者。Enhanced user interface to quickly change the owner of a subscription. 舊版 Reporting ServicesReporting Services 可讓系統管理員使用指令碼變更訂閱擁有者。Previous versions of Reporting ServicesReporting Services allow administrators to change subscription owners using script. SQL Server 2016 (13.x)SQL Server 2016 (13.x) 版本開始,您可以使用使用者介面或指令碼來變更訂閱擁有者。Starting with the SQL Server 2016 (13.x)SQL Server 2016 (13.x) release, you can change subscription owners using the user interface or script. 有使用者離開或在組織中變更角色時,便需要進行變更訂閱擁有者這項一般管理工作。Changing the subscription owner is a common administrative task when users leave or change roles in your organization. SharePoint 與原生模式SharePoint and Native mode
檔案共用訂閱的共用認證Shared credential for file share subscriptions. Reporting ServicesReporting Services 檔案共用訂閱現在同時存有兩個工作流程:Two workflows now exist with Reporting ServicesReporting Services file share subscriptions:

您的 Reporting ServicesReporting Services 系統管理員可以設定單一檔案共用帳戶,可供多個訂用帳戶使用。New in this release, your Reporting ServicesReporting Services administrator can configure a single file share account, that can be used for multiple subscriptions. 檔案共用帳戶是在 Reporting ServicesReporting Services 原生模式設定管理員的 [指定檔案共用帳戶] 中設定。The file share account is configured in the Reporting ServicesReporting Services native mode configuration manager Specify a file share account. 使用者在訂用帳戶設定頁面上選取 [使用檔案共用帳戶] 。On the subscription configuration page, users select Use file share account.

您針對目的檔案共用,使用特定認證設定個別訂閱。You configure individual subscriptions with specific credentials for the destination file share.

您也可以混用兩種方法,讓某些檔案共用訂閱使用中央檔案共用帳戶,而其他訂閱則使用特定認證。You can also mix the two approaches and have some file share subscriptions use the central file share account while other subscriptions use specific credentials.
原生模式Native mode

SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)

SSDT 的新版本包括 SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS)的專案範本:[報表伺服器專案精靈] 與 [報表伺服器專案]。The new release of SSDT includes the project templates for SQL Server 2016 Reporting Services (SSRS)SQL Server 2016 Reporting Services (SSRS): Report Server Project Wizard and Report Server Project. 如需下載 SSDT 的相關資訊,請參閱 SQL Server Data Tools for Visual Studio 2015(適用於 Visual Studio 2015 的 SQL Server Data Tools)。For information about downloading SSDT, see SQL Server Data Tools for Visual Studio 2015.

報表產生器改進Report Builder improvements

新的報表產生器使用者介面 :核心 報表產生器Report Builder 使用者介面現在透過簡化的 UI 元素,具備了新式外觀及操作。New Report Builder User Interface: The core 報表產生器Report Builder user interface is now a modern look and feel with streamlined UI elements.

新增New PreviousPrevious
ssrs_rbfacelift_newssrs_rbfacelift_new ssrs_rbfacelift_oldssrs_rbfacelift_old

自訂參數窗格 :您現在可以自訂參數窗格。Custom Parameters Pane: You can now customize the parameters pane. 使用報表產生器中的設計界面,您可以將參數拖曳到參數窗格中的特定資料行及資料列。Using the design surface in Report Builder, you can drag a parameter to a specific column and row in the parameters pane. 您可以新增及移除資料行以變更窗格配置。You can add and remove columns to change the layout of the pane. 如需詳細資訊,請參閱 自訂報表中的參數窗格 (報表產生器)中建立的行動報表。For more information, see Customize the Parameters Pane in a Report (Report Builder).

[報表資料] 窗格和參數窗格中的參數清單Parameter list in Report Data pane and in parameters pane

高 DPI 支援: 報表產生器Report Builder 支援高 DPI (每英吋點數) 縮放比例及裝置。High DPI Support: 報表產生器Report Builder supports High DPI (Dots Per Inch) scaling and devices. 如需高 DPI 的詳細資訊,請參閱下列主題:For more information on High DPI, see the following:

後續步驟Next steps

Analysis Services 的新功能What's New in Analysis Services
回溯相容性Backward Compatibility
SQL Server 版本所支援的 Reporting Services 功能Reporting Services Features supported by the Editions of SQL Server
升級和移轉 Reporting ServicesUpgrade and Migrate Reporting Services
Reporting ServicesReporting Services

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