Is SSRS 2008 supports exporting to .xlsx format instead of .xls
I have MS Office 2007 installed in my machine. when i export SSRS 2008 report to Excel, i need to save in .xlsx format rather than .xls format. what settings we need to do. pls give me the solution for this. Thanks in advance.
September 18th, 2010 12:13am

Not natively; you need something like Aspose.cells - http://www.aspose.com/categories/ssrs-rendering-extensions/aspose.cells-for-reporting-services/default.aspx
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2010 1:11am

Hi RajeshPeethala, By default, Reporting Services 2008 can only export reports to excel file as XLS format in order to maintain backward compatibility. However, we can use the third party tools to export reports to XLSX format, or we can also implement a custom rendering extension but it is complicated. Another similar thread you can refer to: http://social.msdn.microsoft.com/Forums/en-US/sqlkjreportingservices/thread/568c624c-1256-4918-abc3-c2f57d38e275 For more information about Rendering Extensions in Reporting Services 2008, please see: http://msdn.microsoft.com/en-us/library/ms154606(v=SQL.100).aspx Thank you for your understanding. If you have any question, please feel free to ask. Regards, Tony Chain
September 20th, 2010 10:53am

Tony, Do you have a correct link to the first article you linked to? If I go to the first link, I get "You are not authorized to perform this action."
Free Windows Admin Tool Kit Click here and download it now
December 6th, 2010 2:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics