Women in Technology

Hear us Roar


Article:
  Using the SQL Server 2000 Reporting Services
Subject:   Trying to export large report to excel.
Date:   2005-09-27 08:56:09
From:   tcoggins
I have a large report about 30,500 rows of data. When I try to export to excel it hangs the server up. If I use comma delimeted I have no problems. Any ideas?
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • Trying to export large report to excel.
    2006-11-14 10:56:33  merediths615 [View]

    Did you ever figure this out? We are having the same problem.

    Thanks,
    Meredith
    • Trying to export large report to excel.
      2008-06-10 03:41:16  Ritish Dhir [View]

      Hi wherever you are setting command.
      Use Sqlcommand.Timeout=600;(at your choice 600 equvalent to 10 minutes.By default in asp.net it is set as 30s..)

      Thanks & regards
      Rocky

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >