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: 403

Filed under:

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:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/69545568-73cb-4f4c-8f35-44472ba6d013

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:

http://cid-456117cf53a42144.spaces.live.com/default.aspx

© Stack Overflow or respective owner

Related posts about sql-reporting-services

Password protected PDF/Excel reports using SQL Reporting services

as seen on Stack Overflow - Search for 'Stack Overflow'
I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf. Is there any way to protect the report. >>> More
Error configuring SQL Reporting Services 2005 on Windows 7

as seen on Server Fault - Search for 'Server Fault'
I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an error while switching panels. The most likely cause is an error retrieving WMI properties. The exception… >>> More
SQL Reporting Services - Subreports Broken into multiple columns

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I inherited an SQL Reporting Services .rdl project from somebody and need help fixing some functionality. In each row of the report, there is a subreport. In order to save space the subreport is divided into 3. Such that in each row of the report, it splits the data of the subreport into 3 smaller… >>> More
SQL Reporting Services Daylight saving time query (pt 2)

as seen on Stack Overflow - Search for 'Stack Overflow'
I posted a question a couple of days ago (SQL Reporting Services Daylight saving time query) which was I received an answer for (thanks very much) but did not elaborate on the whole problem I am experiencing. Not only did I require the returned date time format to account for day light saving but… >>> More
SQL reporting services beginner.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone I am not clear with SQL reporting services can someone pls give me breef explanation or post some tutorial with examples and concept explanations. ] Thanks a lot. >>> More

Related posts about sql-server-2008-r2

SQLAuthority News – SQL SERVER 2008 R2 Pricing

as seen on SQL Authority - Search for 'SQL Authority'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing. Official site: What’s New in SQL Server 2008 R2 Editions Editions Per Processor PricingRetail Per Server Plus CAL PricingRetail Parallel Data Warehouse $57,498 Not… >>> More
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced… >>> More
SQLAuthority News SQL SERVER 2008 R2 Pricing

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing.Official site: What’s New in SQL Server 2008 R2 EditionsEditionsPer Processor PricingRetailPer Server Plus CAL PricingRetailParallel Data Warehouse$57,498Not offered via Server… >>> More
Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

as seen on SQL Blog - Search for 'SQL Blog'
Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with… >>> More