Post reply

Export Report Data in to multiple sheets

  • March 6, 2011 at 10:36 pm

    #247747

    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:33 am

    #1295229

    Duplicate post. No replies please.

    Original post can be found here


    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]

Viewing 2 posts - 1 through 1 (of 1 total)

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