CODEWITHSUNDEEP
c#sqlreporting-servicesssrs-2008
John Cooling
John Cooling

Reputation: 415

Report exceeds 256 columns

I've recently discovered that I cannot export a SSRS report to Excel if it contains more than 256 Columns. Is there a work around for this as this is in place for backwards compatibility with Excel 2003 and older versions. I intend to use Excel 2007+ for the reports.

Error Thrown in the Report Designer

Error Thrown in the Report Designer

Edit

I've exported a smaller report to Excel and found that it is merging 2 cells for every column, so in this case the should only be around 210 columns. How can I stop this from happening?

Upvotes: 2

Views: 1541

Answers (1)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

Yes, Excel 2003 supports a maximum of 256 columns. SSRS 2008 generates Excel 2003 documents so you will fall into the same limitations.

Here is what you can do:

  • Upgrade to SSRS 2012 which generates Excel 2007-2010 and supports 16,384 columns
  • Export to CSV instead
  • Re-organize your content to have less columns, here is a workaround for example

Upvotes: 6

Related Questions