Post reply

Download report having more than 256 columns in SSRS 2008 R2 to Excel?

  • June 15, 2012 at 6:22 pm

    #258177

    I've a SSRS 2008 R2 report that have more than 256 columns. When i try to download that to Excel it is failing because of the 256 columns limit. Is there any work around for this to be able to download that to Excel?

    I'm also interested to know if there is a way to export the remaining columns to the next worksheet. For example, my report has 356 columns. So is there a way to export 256 columns into first worksheet and the remaining 100 columns to another worksheet in the same workbook when downloaded to excel?

    Thanks in advance!

  • June 18, 2012 at 6:44 pm

    #1502543

    sql server developer (6/15/2012)

    I've a SSRS 2008 R2 report that have more than 256 columns. When i try to download that to Excel it is failing because of the 256 columns limit. Is there any work around for this to be able to download that to Excel?

    I'm also interested to know if there is a way to export the remaining columns to the next worksheet. For example, my report has 356 columns. So is there a way to export 256 columns into first worksheet and the remaining 100 columns to another worksheet in the same workbook when downloaded to excel?

    Thanks in advance!

    Try CSV format, then open with excel 2008+ and save as xlsx. I know this will work when the row limit is exceeded. I've never had a 356 column wide report! My attention wanes after about column 117...:-P

    You'd have to break up the table to split out the columns onto another tab

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

  • June 18, 2012 at 8:06 pm

    #1502552

    From

    http://msdn.microsoft.com/en-us/library/aa730921(v=office.12).aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel

    The "Big Grid" and Increased Limits in Excel 2007

    The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD).

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • June 18, 2012 at 8:45 pm

    #1502559

    Hi Ron,

    First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2 Excel downloads will get rendered in 2003 format and not 2008. So the number of columns are still limited to 256.

    As per the below link, from SQL Server 2012 onwards excel downloads will get rendered in 2010 because of Excel rendering extension

    http://technet.microsoft.com/en-us/library/dd255234.aspx#ExcelBenefits

    Please let me know if i'm misinterpreting something here!

    Thanks again!

  • June 18, 2012 at 8:47 pm

    #1502561

    Thanks for the instructions! I tried doing that but mine is a matrix report and when downloaded to csv, it is not getting download as Matrix instead the report is getting downloaded unpivoted (Vertically losing the matrix formatting).

    Am i missing something here?

    Thanks in advance!

  • June 19, 2012 at 5:51 am

    #1502745

    sql server developer (6/18/2012)

    Hi Ron,

    First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2 Excel downloads will get rendered in 2003 format and not 2008. So the number of columns are still limited to 256.

    As per the below link, from SQL Server 2012 onwards excel downloads will get rendered in 2010 because of Excel rendering extension

    http://technet.microsoft.com/en-us/library/dd255234.aspx#ExcelBenefits

    Please let me know if i'm misinterpreting something here!

    Thanks again!

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • June 19, 2012 at 5:57 am

    #1502750

    sql server developer (6/18/2012)

    Hi Ron,

    First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2 Excel downloads will get rendered in 2003 format and not 2008. So the number of columns are still limited to 256.

    As per the below link, from SQL Server 2012 onwards excel downloads will get rendered in 2010 because of Excel rendering extension

    http://technet.microsoft.com/en-us/library/dd255234.aspx#ExcelBenefits

    Please let me know if I'm misinterpreting something here!

    Thanks again!

    First off let me state, I have NOT used or attempted to use what is stated here:

    http://technet.microsoft.com/en-us/library/dd255234.aspx#ExcelDifferences

    I am just suggesting that the above may provide a solution to your problem, and for that reason is worth a read by yourself.(Hoping it helps and does not create more confusion). If it does or does not help, please post back, so that others who might have a similar problem will benefit from your experience.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply