Excel Renderer for Excel 2007-2010
SSRS reports are typically viewed using ReportViewer from a web page or Windows application, or by running the report from inside Report Builder. Both methods offer the user the ability to manually export the records and format the report into Microsoft Excel. New to SQL Server 2012 is the Excel rendering extension that is compatible with Excel 2007 and 2010. The format is Office Open XML, rendering to an Excel sheet with an .xlsx extension.
The previous limitation of being able to export only 65,000 rows has now been increased to 1,048,576 rows, which is a vast improvement and will be a welcome feature tomany end users.
Note
The Excel 2003 extension is now deprecated but you can still make use of it by following ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
