What's New in Report Builder for SQL Server 2016
The SQL Server 2016 introduces a number of Reporting Services features.
For information about features in this release for other SQL Server 2016 products and technologies, see What's New in SQL Server 2016.
For the most recent information and resources regarding new features in this release, see Additional information on what is new in SQL Server Reporting Services (SSRS).
The Reporting Services Excel rendering extension, new in SQL Server 2012, renders a report as an Excel document that is compatible with Microsoft Excel 2007-2010 as well as Microsoft Excel 2003 with the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint installed. The format is Office Open XML and the file extension of files is .xlsx.
This Excel-rendering extension removes limitations of the earlier version, compatible with Excel 2003. The following lists the improvement in the rendering extension:
Maximum rows per worksheet is 1,048,576.
Maximum columns per worksheet is 16,384.
Number of colors allowed in a worksheet is approximately 16 million (24-bit color).
ZIP compression provides smaller files sizes.
For more information, see Exporting to Microsoft Excel (Report Builder and SSRS).
The Reporting Services Word rendering extension, new in SQL Server 2012, renders a report as a Word document that is compatible with Microsoft Word 2007-2010 as well as Microsoft Word 2003 with the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint installed. The format is Office Open XML and the file extension of files is docx.
In addition to making the features that are new in Word 2007-2010 available to exported reports, *.docx files of exported reports tend to be smaller. Reports exported by using the Word renderer are typically significantly smaller than the same reports exported by using the Word 2003 renderer.
For more information, see Exporting to Microsoft Word (Report Builder and SSRS).