| title | Release notes for Reporting Services 2017 and later | Microsoft Docs |
|---|---|
| description | Learn details about the changes in SQL Server Reporting Services (SSRS), for versions 2017 and later. |
| ms.date | 11/16/2022 |
| ms.prod | reporting-services |
| ms.prod_service | reporting-services-native |
| ms.technology | reporting-services |
| ms.topic | conceptual |
| ms.reviewer | maggies |
| author | casualoak |
| ms.author | petebro |
| monikerRange | >=sql-server-2017 |
[!INCLUDE ssrs-appliesto] [!INCLUDE ssrs-appliesto-2017-and-later]
This article describes changes in [!INCLUDEssnoversion] [!INCLUDEssRSnoversion] (SSRS), for versions 2017 and later.
For the release notes for Report Viewer controls, see Release Notes for the Report Viewer controls for WebForms and WinForms of SSRS.
::: moniker range="=sql-server-ver16"
(Product Version: 16.0.1112.48)
Initial release.
- Major changes from SQL Server 2019 Reporting Services:
- New portal experience with performance improvements using Angular
- Accessibility fixes to many parts of the portal
- New Power BI Migration experience in the portal
- Ability to turn off size calculation for snapshots via configuration property EnableListHistorySnapshotsSize if History Snapshots page loads slow due to a large number of snapshots
- Security enhancements
- Bug fixes
- Deprecated features:
- Report Parts support
- Discontinued features:
- Pin to PowerBI functionality
- Mobile Reports functionality (.rsmobile) and Mobile Report Publisher
(Product Version: 15.0.1111.106)
Release Candidate 0 (RC0)
- New portal experience with performance improvements using Angular.
- Accessibility fixes to many parts of the Portal.
- Security enhancements.
- Bug fixes.
- Discontinuation of several features: Pin to Power BI, Mobile Reports, and Mobile Report Publisher.
::: moniker-end
(Product Version: 15.0.1102.1002)
- Fixed issue with certain parameters causing connection error to certain data sources.
- Fixed issue with date time in some locales.
- Fixed issue with spacing in PDF exports.
- Updated versions of some utilized open-source software.
- Security fixes
(Product Version: 15.0.1102.962)
| Fixed issue | Details |
|---|---|
| Fixed datetime parameter issue affecting specific locales | |
| Fixed System.FormatException when retrieving data from ESSBASE | |
| Fixed issue where editing security groups on an item could remove all previous settings | |
| Fixed PDF search issue in right-to-left languages |
(Product Version: 15.0.1102.932)
| Fixed issue | Details |
|---|---|
Added <LINK> tag in PDFs exported with accessible PDF enabled on textboxes with 'Go to URL' actions. |
|
Added <UL> and <LI> tags in PDFs exported with accessible PDF enabled for textbox Lists |
|
| Fixed an issue with date parameters in Oracle based reports failing with "ORA-01008: not all variables bound" |
(Product Version: 15.0.1102.911)
| Fixed issue | Details |
|---|---|
| Fixed an issue for registering Report Server instance to enable Pin to Power BI feature | |
| Fixed an issue screen readers reading extra rows and columns for a tablix when exported to MHTML using new HTML DOCTYPE |
(Product Version: 15.0.1102.896)
| Fixed issue | Details |
|---|---|
| Fixed an issue screen readers reading extra rows and columns for a tablix when exported to MHTML | |
| Fixed an issue with Teradata based datasources have NULL value | |
| Fixed an issue with SSRS MHTML renderer using an older HTML DOCTYPE |
(Product Version: 15.0.1102.861)
| Fixed issue | Details |
|---|---|
| Security updates | |
| Constrained Comment attachment support to no longer allow PDF documents | |
| Fixed filename truncation when exporting reports containing a period in the name | |
| Fixed an issue related to Subscriptions and the zh-TW culture that resulted in invalid date format errors | |
| Fixed an issue with certain reports where accessing the parameters option leads to indefinite spinny | |
| Fixed issues relating to single quotes in report names | |
| Fixed an issue in URL Access causing FindString to not locate matches | |
| Fixed an issue where alt text for PDF export weren't correctly encoded for multi-byte characters | |
| Fixed unwanted appearance of an empty image under a linear element | |
| Fixed erroneous Unsupported error for Custom Authentication in Web Edition | |
| Fixed an issue where a screen reader was reading an extra row and extra column in a Tablix | |
| Fixed an image truncation issue with fit to size when zoomed to whole page | |
| Command line upgrade no longer requires EULA flag |
(Product Version: 15.0.1102.675)
Initial release.
(Product Version: 14.0.600.1860)
| Fixed issue | Details |
|---|---|
| Fixed an issue rendering some reports in Edge browser. | |
| Fixed an issue for some locales when working with data from an Essbase datasource. |
(Product Version: 14.0.600.1763)
| Fixed issue | Details |
|---|---|
| Fixed an issue for registering Report Server instance to enable Pin to Power BI feature |
| Fixed issue | Details |
|---|---|
| Security updates | |
| Constrained Comment attachment support to no longer allow PDF documents | |
| Fixed filename truncation when exporting reports containing a period in the name | |
| Fixed an issue related to Subscriptions and the zh-TW culture that resulted in invalid date format errors |
| Fixed issue | Details |
|---|---|
| Updated JQuery UI to 1.12 | |
| Fixed URL case-sensitivity | |
| Fixed Parameter placement when there are many parameters | |
| Fixed FindString not working in HTML5 rendering | |
| Analysis Services Client Libraries updated to address TLS 1.0/1.1 deprecation |
| Fixed issue | Details |
|---|---|
| Security updates | |
| Paginated reports didn't work properly with filter parameters when snapshot is enabled | |
| Users with Browser role and default settings didn't have permissions to download Excel files | |
| Upgrading to Power BI Report Server from SQL Server 2016 Reporting Services failed during upgrade | |
| After you upgrade from SQL Server 2012 Reporting Services, subscriptions failed with "An invalid character was found in the mail header: ','" message | |
| Configuration tool: canceling modal windows in Database section would restart the Reporting Services service | |
| BorderStyle property expression of Textbox controls weren't rendered to Excel format | |
| Pagination issue that could get certain reports stuck with rendering the same page without ever reaching the last page of the report |
| Fixed issue | Details |
|---|---|
| Security updates | |
| Unable to select weekdays when creating a shared weekly schedule | |
| Report doesn't display carriage returns properly in Word format | |
| System Center Operations Manager(SCOM) 2019 no longer works with recent SSRS 2017 upgrades | |
| An error occurred when invoking the authorization extension for shared Dataset | |
| Logic changed on stored procedure GetAllProperties in SSRS 2017 and PBIRS, which causes the Web service endpoint ReportingService2010.GetProperties method unable to get any data for linked report | |
| Simple Grid Row Header in Mobile Report disappears when an Item within the Grid is clicked | |
| Unable to use date field in Data Driven Subscription parameter | |
| Nested tablix shows small font or partial font in SSRS 2016 and later | |
| Subscriptions with DateTime Parameter error out after user with different Locale edits the Subscription | |
| Creating a Data-driven Subscription with Null Delivery Extension is failing with "A delivery error has occurred" | |
| URL encoding is incorrect when setting the value in Excel\Word format |
| Fixed issue | Details |
|---|---|
| Cache report snapshot schedules changes to "Report-specific schedule" after modifying subscription. | |
| rc:Toolbar=false isn't working in Express edition. | |
| Certain Thai characters render incorrectly when exporting paginated reports to PDF. | |
| Deadlock during notification of completed data-driven subscriptions. | |
| Embedded images aren't displayed in certain circumstances when the rc:Toolbar=False parameter used. | |
| Unable to create data driven subscriptions for reports that use cascading parameters. | |
| Unable to edit subscriptions that are configured with an invalid interval. | |
| Security updates. | |
| Linked reports UI isn't showing. | |
| Certain paginated reports with nested tablix controls have incorrect fonts. | |
| Whitespace is incorrectly added to certain paginated reports that contain tablix data regions. | |
| Header rows disappear when expanding the simple data grids of a mobile report. |
The following issue has been fixed:
| Fixed issue | Details |
|---|---|
| Custom Authentication isn't returning correct cookie information. |
| Fixed issue | Details |
|---|---|
| Textbox inside Rectangle causes the rectangle to not grow vertically when rc:Toolbar=False and it has long text. | |
| Text size isn't scaling if pageHeight is less than 0.5 inch. | |
| Deadlock occurs in the SSRS catalog database when it is used with CRM. | |
| Vertically aligned column headers displayed incorrectly when scrolling down in report. | |
| Users added to System Center Operations Manager Reporting Role have access blocked to SSRS web portal. | |
| Thai character isn't exported correctly into the PDF. | |
| Browser Role Behavior Change. | |
| rc:Toolbar=false doesn't work in Express edition. | |
| Missing the vertical scrollbar in the parameter prompt area. | |
| Updated Mobile Report Runtime. |
| Fixed issue | Details |
|---|---|
| Data Driven Subscription page doesn't show the Delivery Option once it is created. | |
| Upgrading SSRS 2012 to SSRS 2017 results in RSManagement throwing an exception every few seconds. | |
| Cannot change defaults values for multi-value parameters in IE11. | |
| Schedules are empty whenever shared schedule is executed. |
| Fixed issue | Details |
|---|---|
| Report Parameter visibility in a linked report is reverted after editing its properties. | |
| URL Parameter rc:Toolbar=false doesn't work in Express edition. | |
| Having expressions in a Textbox with the CanGrow property set to false results in values not displaying. | |
| Added Learn more link for product key in setup. | |
| Web portal with custom forms authentication ignores sliding expiration cookie. | |
| Export to Word creates unequal row height if row content is empty. |
Some security updates were implemented.
Resolved the issues with SKU upgrade.
Initial release.
What's New in Reporting Services (SSRS)?
More questions? Try asking the Reporting Services forum.