What's New in Reporting Services (SSRS)
Updated: January 4, 2016
Applies To: SQL Server 2016 Preview
This topic summarizes the changes and updates in the SQL Server 2016 release of Reporting Services. This document notes the version of the release that features first appeared. For example [CTP 2.3] represents "Community Technology Preview 2.3 (CTP 2.3)". For information on what's new in other areas of SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2), see What's New in SQL Server 2016, February Update.
To download SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2), go to Evaluation Center.
Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2016 already installed.
For the current release notes, see SQL Server 2016 Release Notes.
[CTP 3.2]Starting with CTP 3.2, a new Reporting Services web portal is available. This is an updated, modern, portal which incorporates KPIs, Mobile Reports and Paginated Reports. Currently, the portal is for consumption. For adding new data sources, data sets and paginated reports, you will need to switch to the classic Report Manager. To create Mobile Reports, you will need the Mobile Report Publisher.
You can browse to this portal by going to http://<server>/reports_preview.
For more information about the web portal, see Web portal (SSRS Native Mode).
[CTP 3.2] The SQL Server Mobile Report Publisher allows you to create and publish SQL Server mobile reports to your Reporting Services web porta.
For more information, see Create and publish mobile reports with SQL Server Mobile Report Publisher.
[CTP 3.2]The Power BI Mobile app for iOS on iPad and iPhone can now display SQL Server mobile reports hosted on your local report server.
You can't connect by default without some configuration changes. 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.
[CTP 3.1]Starting with CTP 3.1, Reporting Services SharePoint mode is supported. SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2) Reporting Services supports integration with SharePoint 2013 and SharePoint 2016. For more information, see:
[CTP 3.0] While viewing a report in Report Manager, you can select report items and pin them to a Power BI dashboard. The items you can pin are charts, gauge panels, maps, and images. You can (1) select from your available dashboards and (2) configure how often the data is refreshed to the dashboard tile.
For more information, see Power BI Report Server Integration (Configuration Manager) and Pin Reporting Services items to Power BI Dashboards.
[CTP 3.0] The new release of SSDT includes the project templates for SQL Server 2016 Reporting Services (SSRS): Report Server Project Wizard and Report Server Project. For information about downloading SSDT, see SQL Server Data Tools for Visual Studio 2015.
[CTP 2.4] The Microsoft PowerPoint (PPTX) format is a new SQL Server 2016 Reporting Services (SSRS) rendering extension. You can export reports in the PPTX format from the usual applications; Report Builder, Report Designer (in SSDT), Report Manager. For the example the following image shows the export menu from Report Builder. For more information, see Export Reports (Report Builder and SSRS).
You can also select the PPTX format for subscription output and use Report Server URL access to render and export a report. For example the following URL command in your browser exports a report from a named instance of the report server.
For more information, see Export a Report Using URL Access.
[CTP 2.4] The report viewer toolbar ActiveX print experience has been replaced with a modern PDF based experience that works across the matrix of supported browsers, including Microsoft Edge. No more ActiveX controls to download! Depending on the browser you use and the PDF viewing applications and services you have installed, Reporting Services will either open a print dialog to print your report or prompt you to download a .PDF file of your report. As an administrator, you can still disable client side printing from Management Studio. For more information, see Enable and Disable Client-Side Printing for Reporting Services.
[CTP 2.4] 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.
[CTP 2.3] A new HTML5 rendering engine that targets modern web "full" standards mode and modern browsers. The new rendering engine no longer relies on quirks mode used by a few older browsers. The new rendering engine is used by default but you have the option of switching back to the previous rendering engine and providing feedback to Microsoft on the new HTML5 approach.
When you preview reports in Report Manager, you will see an information bubble noting you are using the new HTML 5, full standards rendering but you can switch to the old rendering engine. The bubble appears the fist few times you preview a report.
The ribbon allows you to toggle between:
-Comparability mode and running the old rendering engine.
-Preview of the new HTML 5 rendering mode
To provide feedback on the new rendering engine, see the MSDN forum SQL Server Reporting services.
For more information on browser support, see Browser Support for Reporting Services and Power View.
[CTP 2.3] The core Report Builder user interface is now a modern look and feel with streamlined UI elements.
[CTP 2.3]. Enhance your reports with Tree Map and Sunburst charts, great ways to display hierarchal data.
For more information, see Tree Map and Sunburst Charts in Reporting Services.
[CTP 2.0] SQL Server 2016 Reporting Services (SSRS) supports the current versions of Microsoft .NET Framework 4. This includes version 4.0 and 4.5.1. If no version of .Net Framework 4.x is installed, SQL Server setup installs .NET 4.0 during the feature installation step.
[CTP 2.0] Enhancements to Reporting Services Subscription features:
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.
For more information, see Disable or Pause Report and Subscription Processing.
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 and Native mode
Change subscription owner. Enhanced user interface to quickly change the owner of a subscription. Previous versions of Reporting Services allow administrators to change subscription owners using script. Starting with the SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2) 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 and Native mode
Shared credential for file share subscriptions. Two workflows now exist with Reporting Services file share subscriptions:
New in this release, your Reporting Services administrator can configure a single file share account, that is used for one to many subscriptions. The file share account is configured in the Reporting Services native mode configuration manager Specify a file share account, and then on the subscription configuration page, users select Use file share account.
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.