| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | ||
|---|---|---|---|---|---|---|---|---|---|---|
What's new in SQL Server Reporting Services (SSRS) |
Learn about what's new in the different versions of SQL Server Reporting Services (SSRS), including changes to the major feature areas. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
reporting-services |
whats-new |
|
[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016-and-later] [!INCLUDEssrs-appliesto-not-pbirsi]
Learn about what's new in the different versions of SQL Server [!INCLUDEssRSnoversion]. This article covers the major feature areas and is updated as new items are released.
For more information about SSRS, see What is SQL Server Reporting Services (SSRS).
For information about Power BI Report Server, see What's new in Power BI Report Server.
::: moniker range="=sql-server-ver16"
Download SQL Server 2022 Reporting Services from the Microsoft Download Center.
This release introduces the new [!INCLUDE sssql22-md] Reporting Services (SSRS). Innovation, creation, and design efforts focus on giving everyone the ability to achieve more. Designing for inclusivity reflects how people adapt to the world around them. In this new release of SSRS, significant accessibility improvements ensure broader empowerment and usability for users. The release includes:
- Windows Narrator support enhancements for the new Windows OS (Operating Systems) and Windows Server
- Security enhancements
- Browser performance improvements with Angular
- Accessibility bug fixes
- Support for [!INCLUDE sssql22-md] instances report server catalog
- Reliability updates
The web portal was updated with a contemporary look.
:::image type="content" source="../reporting-services/media/report-server-2022-web-portal.png" alt-text="Screenshot of the updated [!INCLUDE sssql22-md] Reporting Services web portal.":::
In 2020, deprecation of Report Server features Pin to Power BI, Mobile Reports, and Mobile Report Publisher was announced. These features were removed from versions of SQL Server starting with [!INCLUDE sssql22-md] and are no longer supported. SQL Server 2016, SQL Server 2017, and SQL Server 2019 are supported in maintenance mode until End of Service (EOS) for existing customers.
When a feature is deprecated, it's in maintenance mode only. There's no new feature development, including changes related to interoperability with new features. Deprecated features usually remain in future releases to make upgrades easier. However, in rare situations, the feature might be permanently removed from Reporting Services if it limits future innovations.
Note
For new development work, don't use deprecated features.
::: moniker-end
::: moniker range=">=sql-server-ver15"
Download SQL Server 2019 Reporting Services from the Microsoft Download Center.
You can now host a database catalog used for SSRS in an Azure SQL Managed Instance (MI) either on a virtual machine (VM) or in your data center. Support is limited to database credentials for the connection to SQL MI.
You can connect to Power BI datasets by using either Microsoft Report Builder or SQL Server Data Tools (SSDT). Then you can publish those reports to SSRS 2019 by using SQL Server Analysis Services (SSAS) connectivity and use a stored Windows username and password to enable the scenario. For more information about SSAS, see - What's new in SQL Server Analysis Services
When you author reports, use tooltips to specify text for each element on the report. Screen reader technology identifies these tooltips properly.
[!INCLUDE entra-id]
With Microsoft Entra application proxy, you no longer need to manage your own web application proxy to allow secure access through the web or mobile apps.
Sets header values for all URLs matching the specified regex pattern. You can update the custom header value with valid XML to set header values for selected request URLs. Administrators can add any number of headers in the XML. For more information, see Custom headers.
[!INCLUDE sssql19-md] supports transparent data encryption (TDE) for the SSRS catalog database in the Enterprise and Standard editions.
The newly released version of Report Builder is fully compatible with the 2016, 2017, and 2019 versions of Reporting Services. It's also compatible with all released and supported versions of Power BI Report Server.
::: moniker-end
::: moniker range=">=sql-server-2017"
Download SQL Server 2017 Reporting Services from the Microsoft Download Center.
Comments are available for reports. Comments can add perspective and help you collaborate with others. You can also include attachments with comments.
:::image type="content" source="media/what-s-new-in-sql-server-reporting-services-ssrs/report-server-comments.png" alt-text="Screenshot of the Comments button on a report.":::
For more information, see Add comments to a report in a report server - Power BI Report Server.
To enable development of modern applications and customization, SSRS supports a fully OpenAPI-compliant RESTful API. For information about the full API specification, see SwaggerHub.
In Report Builder and SSDT, you can create native DAX queries against supported SSAS tabular data models. Use the query designer in both tools to drag and drop the fields you want. The DAX query is then generated for you.
For more information, see Reporting Services blog.
- Download SQL Server Report Builder.
- Download SQL Server Data Tools.
Note
You can only use the query designer for DAX with SSAS tabular data sources built in SQL Server 2016+.
SharePoint integrated mode is deprecated after SQL Server 2016. To add Reporting Services reports to SharePoint, use the Report Viewer web part on a SharePoint site - Reporting Services.
::: moniker-end
Reporting Services [!INCLUDEssRSWebPortal]
A new [!INCLUDEssRSnoversion] [!INCLUDEssRSWebPortal] is available. The updated web portal includes:
- Key performance indicators (KPIs)
- Mobile reports
- Paginated reports
- Excel files
- Power BI Desktop files
The [!INCLUDEssRSWebPortal] replaces Report Manager from previous releases.
To create mobile reports, you need the [!INCLUDESS_MobileReptPub_Short].
[!INCLUDE ssrs-mobile-report-deprecated]
For more information about the [!INCLUDEssRSWebPortal], see The web portal of a report server (Native mode).
:::image type="content" source="../reporting-services/media/ssrsportal.png" alt-text="Screenshot of the SQL Server Reporting Services portal.":::
Custom branding for the [!INCLUDEssRSWebPortal]
You can customize the [!INCLUDEssRSWebPortal] with your organization's logo and colors by using a branding pack.
For more information about custom branding, see Brand the web portal.
KPIs in the [!INCLUDEssRSWebPortal]
Create KPIs directly in the [!INCLUDEssRSWebPortal] so that they are contextual to the current folder. 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.
:::image type="content" source="../reporting-services/media/ssrs-webportal-kpi.png" alt-text="Screenshot of the KPIs in the SQL Server Reporting Services portal.":::
For more information, see Work with KPIs in Reporting Services.
Reporting Services mobile reports are dedicated reports that are optimized for a wide variety of form factors. They provide an optimal experience for users who access reports on mobile devices. Mobile reports feature an assortment of visualizations, from time, category, and comparison charts, to tree maps and custom maps.
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 that has adjustable grid rows and columns. The flexible mobile report elements automatically scale to fit any screen size. Save the mobile reports to a Reporting Service server, and view and interact with them in a browser or the Power BI mobile app. You can use the following mobile device types to access the reports:
- iPad
- iPhones
- Android phones
- Any Windows device
The [!INCLUDESS_MobileReptPub_Long] allows you to create and publish SQL Server mobile reports to your [!INCLUDEssRSnoversion] [!INCLUDEssRSWebPortal].
:::image type="content" source="../reporting-services/media/ss-mrp-layouttabsm.png" alt-text="Screenshot of the SQL Server Mobile Report Publisher interface.":::
For more information, see Create mobile reports with SQL Server Mobile Report Publisher.
The Power BI Mobile app for iOS on iPad and iPhone can display SQL Server mobile reports hosted on your local report server.
:::image type="content" source="../reporting-services/media/ss-mrp-ipad-homesm.png" alt-text="Screenshot of the interface for the Power BI Mobile app for iOS.":::
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.
[!INCLUDEsssql15-md] [!INCLUDEssRSnoversion] supports integration with SharePoint 2013 and SharePoint 2016.
For more information, see:
- Supported combinations of SharePoint and Reporting Services server
- Where to find the Reporting Services add-in for SharePoint Products
- Install Reporting Services 2016 in SharePoint mode
SSRS supports the current versions of Microsoft .NET Framework 4, including version 4.0 and 4.5.1. If a 4.x version of .NET Framework isn't already installed, [!INCLUDEssNoVersion-md] setup installs .NET 4.0 during the feature installation step.
HTML 5 Rendering Engine: A new HTML5 rendering engine that targets web "full" standards mode and contemporary browsers. The new rendering engine no longer relies on quirks mode used by some older browsers.
For more information on browser support, see Browser support for Reporting Services and Power View.
Paginated reports: Design beautifully paginated reports with updated styles for charts, gauges, maps, and other data visualizations.
Treemap and sunburst Charts: Enhance your reports with Treemap :::image type="content" source="../reporting-services/media/ssrs-treemap-icon.png" alt-text="Icon of the button for creating a treemap chart."::: and Sunburst :::image type="content" source="../reporting-services/media/ssrs-sunburst-icon.png" alt-text="Icon of the button for creating a sunburst chart."::: charts, great ways to display hierarchical data. For more information, see Treemap and sunburst charts in a paginated report in SQL Server Reporting Services.
Embed reports: Embed mobile and paginated reports in other web pages and applications by using an iframe and URL parameters.
Pin Report Items to a Power BI Dashboard: While viewing a report in the [!INCLUDEssRSWebPortal], select report items and pin them to a [!INCLUDEsspowerbi] dashboard. The items you can pin are charts, gauge panels, maps, and images. You can:
- Select a group that contains the dashboard you want to pin to.
- Select a dashboard you want to pin the item to.
- Select a frequency of updates you want to schedule.
:::image type="content" source="../reporting-services/media/ssrs-pin-to-powerbi.png" alt-text="Screenshot of the Pin to Power BI Dashboard dialog.":::
Note
[!INCLUDEssRSnoversion] subscriptions manage the report refresh. After the item is pinned, you can edit the subscription and configure a different refresh schedule.
For more information, see Power BI report server integration (Configuration Manager) and Pin Reporting Services paginated report items to dashboards in Power BI.
PowerPoint Rendering and Export: The Microsoft PowerPoint (.pptx) format is a new [!INCLUDEssRSCurrent] rendering extension. You can export reports in the .pptx format from the usual applications: Report Builder, Report Designer (in SSDT), and the [!INCLUDEssRSWebPortal]. For example, the following image shows the export menu from the [!INCLUDEssRSWebPortal].
:::image type="content" source="../reporting-services/media/ssrs-export-powerpoint.png" alt-text="Screenshot of the Export list with the PowerPoint option highlighted.":::
You can also select the .pptx format for subscription output and use Report Server URL access to render and export a report. For example, add the following URL command t0 your browser to export 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
For more information, see Export a report by using URL access.
PDF Replaces ActiveX for Remote Printing: The report viewer toolbar prints by using PDF instead of ActiveX controls. Most browsers, including Microsoft Edge, support the new report viewer. There are no more ActiveX controls to download. Depending on the browser you use and the PDF viewing applications and services you installed, [!INCLUDEssRSnoversion] either a print dialog opens to print your report, or you can download a .PDF file. As an administrator, you can still disable client-side printing from [!INCLUDEssManStudio].
For more information, see Enable and disable client-side printing for Reporting Services.
:::image type="content" source="../reporting-services/media/ssrs-pdf-printing.png" alt-text="Screenshot of the Print dialog box for a PDF report.":::
| Feature | Description | Supported server mode |
|---|---|---|
| Enable and disable subscriptions | New user interface options allow you to quickly disable and enable subscriptions. The disabled subscriptions maintain their other configuration properties, such as schedule, and can be easily enabled. :::image type="content" source="../reporting-services/media/ssrs-enable-disable-subscriptions.png" alt-text="Screenshot of the Enable, Disable, and Delete options."::: For more information, see Disable or pause report and subscription processing. |
Native mode |
| Subscription description | When you create a new subscription, you can 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 allow you to change the owner of a subscription. Previous versions of [!INCLUDEssRSnoversion] allow administrators to change subscription owners using script. Starting with the [!INCLUDEsssql15-md] release, you can change subscription owners by 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 | New in this release, your [!INCLUDEssRSnoversion] administrator can configure a single file share account that you can use for multiple subscriptions. The file share account is configured in the [!INCLUDEssRSnoversion] Native mode configuration manager Specify a file share account. On the subscription configuration page, select Use file share account. You configure individual subscriptions with specific credentials for the destination file share. You can also mix these 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 [!INCLUDEssRSCurrent], Report Server Project Wizard, and Report Server Project. For information about downloading SSDT, see Install SQL Server Data Tools (SSDT).
New Report Builder User Interface: The core [!INCLUDEssRBnoversion] user interface has an updated look and feel with streamlined UI elements.
| New | Previous |
|---|---|
| :::image type="content" source="../reporting-services/media/ssrs-rbfacelift-new.png" alt-text="Screenshot of the new Report Builder interface."::: | :::image type="content" source="../reporting-services/media/ssrs-rbfacelift-old.png" alt-text="Screenshot of the previous Report Builder interface."::: |
Custom Parameters Pane: You can now customize the parameters pane. By 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 paginated report (Report Builder).
:::image type="content" source="../reporting-services/media/ssrs-customizeparameter-parameterlist-reportdatapane.png" alt-text="Screenshot of the Parameter list in the Report Data pane and the parameters pane for a selected parameter." lightbox="../reporting-services/media/ssrs-customizeparameter-parameterlist-reportdatapane.png":::
High Dots Per Inch (DPI) Support: [!INCLUDEssRBnoversion] supports High DPI scaling and devices. For more information on High DPI, see: