How to export data from Report builder 2.0 to Excel 2007 format?

Hello, With Excel 2007 format do you mean the new XLSX format? Actually it's not possible to render a XLSX file, see also thread Problem: export to excel 2007 in SSRSOlaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hi BharatJoshi, SSRS does not export directly to the xlsx format (the Office 2007 format). It does export to the .xls format and that format is fully supported in Office 2007. Users will be able to open, view and edit the reports without any issue. As far as adding direct support for the Office 2007 formats is concerned, it is something that we are considering for a future release. There are two third party components available in the market which support excel 2007 format. Here are the links: 1. http://www.aspose.com/categories/ssrs-rendering-extensions/aspose.cells-for-reporting-services/default.aspx 2. http://officewriter.softartisans.com/officewriter-250.aspx Except the above, you can wirte your own custom extension by extending the render interface, for more information about Rendering Extensions please see: http://msdn.microsoft.com/en-us/library/ms154606.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

So how do we get around the row constraint of 65k when exporting to excel?