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 the instructions here, as you need to use the Microsoft Office Compatibility Pack: http://technet.microsoft.com/en-us/library/dd255234(v=sql.110).aspx .
To render a report to Excel 2007 or higher, you continue to do this from the button onthe report...