Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS

Author  Topic 

satheesh
Posting Yak Master

152 Posts

Posted - 2014-10-01 : 06:05:21
Hi All,

I am currently exporting scheduled report in excel format via SSRS subscription and the report is getting deposited in 97-2003 (.xls)format. I am using SQL Server 2008 R2 version

Now i need to export the report in .XLSX format. What i need todo to upgrade the exporting excel version (i.e .XLS to .XLSX format ) as .XLXS version is only available from Excel 2007 and later version.

Your help regarding this will be highly appreciated.


Thanks

Regards,
SG

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2014-10-01 : 06:11:50
Sql server 2008 does not support exporting files to .xlsx format. You need to use either SSRS 2012 or some third party tools.

Harsh Athalye
http://in.linkedin.com/in/harshathalye/
Go to Top of Page

satheesh
Posting Yak Master

152 Posts

Posted - 2014-10-01 : 06:40:08
Thanks Harsh
Go to Top of Page
   

- Advertisement -