I created a report that opens in Excel format from an ASP.NET form. My first report was build with SSRS 2008 and I discovered that SSRS 2008 exports to xls format which has a 256 column limit. I got lucky since we just deployed SSRS 2012. However, I'm still
getting the same error with a 256 column limit. This only happens when I open the exported file. If I save it locally and open the report, everything works. Am I missing something?
jlamorte
Member
48 Points
35 Posts
Export to Excel with more than 256 Columns
Oct 24, 2012 06:31 PM|LINK
I created a report that opens in Excel format from an ASP.NET form. My first report was build with SSRS 2008 and I discovered that SSRS 2008 exports to xls format which has a 256 column limit. I got lucky since we just deployed SSRS 2012. However, I'm still getting the same error with a 256 column limit. This only happens when I open the exported file. If I save it locally and open the report, everything works. Am I missing something?
ashkc
Participant
960 Points
200 Posts
Re: Export to Excel with more than 256 Columns
Jan 09, 2013 10:04 AM|LINK
SSRS 2012 also exports to xls format which has a 256 column limit i think...
ManikandanUl...
Participant
850 Points
253 Posts
Re: Export to Excel with more than 256 Columns
Jan 09, 2013 10:07 AM|LINK
use excel 2007 and above...
Click "…Mark As Answer" if my reply helpful....
kkranthikuma...
Member
44 Points
12 Posts
Re: Export to Excel with more than 256 Columns
Jan 09, 2013 07:08 PM|LINK
Use Excel renderers, you can have 16,384 maximum columns per worksheet.
Use below link for more details
http://msdn.microsoft.com/en-us/library/dd255234%28v=sql.110%29.aspx