SSRS - SQL Server Forums

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/

satheesh
Posting Yak Master

152 Posts

Posted - 2014-10-01 : 06:40:08

Thanks Harsh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources