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?

Showing messages 1 through 2 of 2.

• Trying to export large report to excel.
  2006-11-14 10:56:33  merediths615 [Reply | 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 [Reply | 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