Post reply

EXPORT TO EXCEL IN REPORTVIEWER

  • February 9, 2012 at 11:41 pm

    #255300

    How can i export a report to excel that has more than 1,50,000 rows. My present application is based on .NET Framework 2.0 and reportviwer 2005.

    Please Suggest...

  • February 10, 2012 at 1:43 am

    #1445393

    ssubudhib (2/9/2012)

    How can i export a report to excel that has more than 1,50,000 rows. My present application is based on .NET Framework 2.0 and reportviwer 2005.

    Please Suggest...

    You can't. Excel 2003 can only handle around 65000 rows.

    In my opinion, a report with more 1000 rows is not a report, it is a datadump and there are other tools for that.

    You could try exporting to .CSV and then read the file in an Excel 2007 or 2010 file, which can handle more rows.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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