Post reply

SSRS expeort to Excel Limitations.

  • September 25, 2009 at 2:18 pm

    #214859

    Hi members,

    Can anyone tell me what the limitations are when a report is exported to Excel sheet..like the rows limitation etc..

    If there is a row limitation per sheet , how to export the report to two different sheets on the same Excel sheet.

    Thanks,

    Nemo

  • September 25, 2009 at 8:23 pm

    #1058716

    If remember correctly Excel 2003 comes with a size limitation but it was fixed in Excel 2007 but I could be wrong so check.

    Kind regards,
    Gift Peddie

  • September 28, 2009 at 6:38 am

    #1058968

    Excel 2003 hat a max dimension of 65'335 Rows x 256 columns

    In excel 2007 this has greatly increased, but still not to infinity. I guess that just nobody has reached the end yet 🙂

  • September 28, 2009 at 8:39 am

    #1059024

    Thank u guys..

    I have one more question...

    Can i export two different reports to same excel sheet?? If so how can i do that...

    Thanks,

    Nemo

  • September 28, 2009 at 8:45 am

    #1059026

    .

  • September 28, 2009 at 9:04 am

    #1059036

    You could create a new report and add the reports you want to merge as sub-reports.

    Please open new threads for new questions....

  • September 29, 2009 at 1:38 am

    #1059338

    Excel 2007:

    Row Limit: 1,048,576

    Column Limit: 16,384

    I've not played around with SSRS 2008, does anyone know if it uses Excel 2003 or 2007 row and column limits?

  • September 29, 2009 at 2:50 am

    #1059347

    @Carleton: SSRS 2008 delivers .xls files, not .xlsx, when exporting to excel. I assume that it uses the Excel2003-Renderer.

  • September 29, 2009 at 3:38 pm

    #1059744

    SSRS 2008 does not use the 2007 Excel rendering engine. You are still under the limit of 2003. You can export to CSV and then open in Excel. It's not the best solution but is a work around.

  • September 29, 2009 at 4:00 pm

    #1059752

    Thanks Dave.

    Does SQL 2008 SSIS play nicely with Excel 2007?

    (sorry for hijacking this thread)

  • September 30, 2009 at 5:36 am

    #1059882

    Yes, as long as you're not running your packages in 64-bit mode, but that's an issue with 2003 as well. My preference is to convert the Excel files to CSV wherever possible. I've also had issue with SSIS picking wrong data type as it only samples the first few hundred rows in the spreadhseet.

  • September 30, 2009 at 10:01 am

    #1060065

    Very helpful, thanks.

  • September 30, 2009 at 1:42 pm

    #1060160

    You're welcome. Not sure if you'll be going to PASS this year in Seattle but if you are, it's worth it to check out any seminars Brian Knight is running. He's very informative when it comes to SSIS.

  • October 6, 2009 at 11:57 pm

    #1062592

    Hi.

    I have a method.

    First, you can export those two reports to two different sheets of Excel.

    Then, you can add the data of the second sheet to the first sheet.

    Do you think it is ok?

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 14 posts - 1 through 13 (of 13 total)

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