What's new in Reporting Services (SSRS)

 

Updated: September 14, 2016

Applies To: SQL Server 2016

needhelp Need help? MSDN forum | stackoverflow | Log an issue or suggestion at Microsoft Connect

Learn about what is new in the SQL Server 2016 release of Reporting Services. This covers the major feature areas and is updated as new items are released.

For information on what's new in other areas of SQL Server 2016, see What's New in SQL Server 2016.

Download download

  • To download SQL Server 2016, go to Evaluation Center.

  • Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2016 already installed.

note For the current release notes, see SQL Server 2016 Release Notes.

A new Reporting Services web portal is available. This is an updated, modern, portal which incorporates KPIs, Mobile Reports, Paginated Reports, Excel and Power BI Desktop files. The web portal replaces Report Manager from previous releases. You can also download Mobile Report Publisher and Report Builder from the web portal without the need of ClickOnce technology.

To create Mobile Reports, you will need the Mobile Report Publisher.

For more information about the web portal, see Web portal (SSRS Native Mode).

ssRSPortal

Custom branding for the web portal

You 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

Key performance indicators (KPI) in the web portal

You can create KPIs direct in the web portal that are contextual to the folder you are in. When creating KPIs, you can choose dataset fields and summarize those values. You can also select related content to drill-through to more details.

ssrs-webportal-kpi

For more information, see Working with KPIs in the web portal

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 a assortment of visualizations, from time, category, and comparison charts, to treemaps and custom maps. Connect your mobile reports to a range of data sources, including on-premises SQL Server Analysis Services multidimensional and tabular data. Lay out your mobile reports on a design surface with adjusting grid rows and columns, and flexible mobile report elements that scale well to any screen size. Then save these mobile reports to a Reporting Service server, and view and interact with them in a browser or in the Power BI mobile app on iPads, iPhones, Android phones and Windows 10 devices.

Mobile Report Publisher

The SQL Server Mobile Report Publisherallows you to create and publish SQL Server mobile reports to your Reporting Services web portal.

SS_MRP_LayoutTabSmall

For more information, see Create mobile reports with SQL Server Mobile Report Publisher.

SQL Server mobile reports hosted in Reporting Services available in Power BI Mobile app

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_HomeSm

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.

SQL Server 2016 Reporting Services supports integration with SharePoint 2013 and SharePoint 2016.

For more information, see:

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.

HTML 5 Rendering Engine: 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.

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.

Tree Map and Sunburst Charts: Enhance your reports with Tree Map ssrs_treemap_icon and Sunburst ssrs_sunburst_icon charts, great ways to display hierarchal data. For more information, see Tree Map and Sunburst Charts in Reporting Services.

Report embedding: You can now embed mobile and paginated reports in other web pages, and applications, by using an iframe along with URL parameters.

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 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 too and (3) select how frequently you want the tile updated in the dashboard. note The refresh is managed by Reporting Services subscriptions and after the item is pinned, you can edit the subscription and configure a different refresh schedule.

ssRS_Pin_to_PowerBI

For more information, see Power BI Report Server Integration (Configuration Manager) and Pin Reporting Services items to Power BI Dashboards.

PowerPoint Rendering and Export: 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), and the web portal. For the example the following image shows the export menu from the web portal.

ssrs-export-powerpoint

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.

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

For more information, see Export a Report Using URL Access.

PDF Replaces ActiveX for Remote Printing: 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.

ssrs-pdf-printing

FeatureSupported 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-subscriptions

For 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 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 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.
Native mode

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.

New Report Builder User Interface: The core Report Builder user interface is now a modern look and feel with streamlined UI elements.

NewPrevious
ssrs_rbfacelift_newssrs_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

High DPI Support: Report Builder for SQL Server 2016 supports High DPI (Dots Per Inch) scaling and devices. For more information on High DPI, see the following:

What's New in Analysis Services
SQL Server 2016 Release Notes
Backward Compatibility
Reporting Services Features Supported by the Editions of SQL Server 2016
Upgrade and Migrate Reporting Services
Reporting Services (SSRS)

needhelp Need help? MSDN forum | stackoverflow | Log an issue or suggestion at Microsoft Connect

Community Additions

ADD
Show: