November 6, 2017 at 9:22 am
Hi
IN a SSRS report when i am trying to export to excel it gives error since no of columns is more than 256. I am using Sql 2008
How this limitation can be resolved. Isn't it possible if 256 columns are done then the remaining columns are displayed in second sheet.
Thanks
November 6, 2017 at 9:41 am
To export more than 256 columns in SSRS 2008 you'll need to split your data in your report into two separate tablixes in your report and insert a page break between the two tablixes; you can't have it automagically spill onto a second worksheet.
SSRS 2008 exports as an xls file when using the Excel Format, which only supports up to 256 columns and 65,536 rows. SSRS 2012 onwards is uses the xlsx format, which supports up to 16,384 columns and 1,048,576 rows.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 6, 2017 at 9:53 am
Hi
How it can be split into 2 Tablixes
Thanks
November 6, 2017 at 10:09 am
Create 2+ tablixes on your report, put the first 256, or so, columns in the first tablix, then the next 256 in the 2nd tablix, the next 256 in the 3rd, then... you get the idea.
Also, ensure you put a page break at the end of each tablix (apart from the last).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 6, 2017 at 11:03 am
Hi
It is Matrix Report. Columns are added dynamically
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply