Post reply

Exporting Data to Excel in multiple sheets

  • March 6, 2011 at 10:35 pm

    #246574

    Hi All,

    I am using Excel 2003 and SSRS 2005.

    One of my reports is having so many records (Records > 1 lac). While exporting to Excel, it is giving the error and export functionality is failed to export the data to excel. So in my investigation i found that excel 2003 will hold only 65,535 records. If more that 65,535 it will gives an error.

    But in this case i should export all the 1 lac rows in to excel. But it is not possible in to single sheet so i want to the data should be exported in to multiple sheets.

    So please help me to export this data in to multiple sheets. It is very urgent to me.

    NOTE: Client is not interested to migrate to Office 2010 and also SSRS2008.

    Thanks and Regards,

    Srinadh.

  • March 7, 2011 at 3:36 am

    #1295232

    Did you try to google it?

    I'm sure there are many solutions out there.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • March 8, 2011 at 4:11 am

    #1295759

    Have you tried exporting to CSV and then opening the CSV in Excel.

  • March 8, 2011 at 11:25 am

    #1296034

    We support multi-sheet export to Excel in our Analyzer product, but of course you'd need to get your data into an Analyzer report first (on multiple sheets) and then export the data to an Excel spreadsheet which would then also have multiple sheets.

    You can download the eval at http://www.strategycompanion.com if you want to try it.

  • March 8, 2011 at 2:15 pm

    #1296150

    Lutz is right, Google it and you should see lots of options. To help you narrow it down, look for page breaks. I've been having issues getting it to work in 2008 R2, but it's supposed to work for 2005.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • March 9, 2011 at 10:36 am

    #1296647

    Instead of creating 1 table on the report, create 2 tables. 1st table will have 65000 rows and other table will have rest of the rows. Put logic on rowId or something to filter data. Then in second table properties, select "Insert Page break before this table". That's it, now when you export it to excel, You will have 2 tabs. Try it ...

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

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