how to get SSRS 2008 R2 to export/render in Excel 2007 format?
Posted
by James Manning
on Stack Overflow
See other posts from Stack Overflow
or by James Manning
Published on 2010-04-12T14:35:04Z
Indexed on
2010/04/14
13:43 UTC
Read the original article
Hit count: 359
sql-reporting-services
|sql-server-2008-r2
I have a report that has ~1k columns and ~17k rows and I'm trying to render it to Excel 2007 with SSRS 2008 R2 Nov CTP.
SSRS team members have mentioned in multiple places that Excel 2007 format is included in 2008 R2, for instance:
Now, it's certainly possible that it just hasn't made it into the product yet (at least as of Nov CTP), and if that's the case, that would be good to know, too (and ideally when it would be in the product).
The repro report and data (along with attempts showing the existing interface still does Excel 2003 format) are attached to the bottom of this blog post, FWIW:
© Stack Overflow or respective owner