How do I speed up Excel exporting?

[mathew1955]

I am exporting to excel through CR 8.0 and the report seems to be take a tremedously long time to export? Any expanation of why this may be occuring or tips appreciated.

 

[kenhamady]

Where is the time spent:
Reading the data
Processing the data
Exporting the data

How many records and how much time? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[mathew1955]

Thanks for responding. The problem seems to be in the exporting. 14,000 records and it has exported 6400 and is clicking along at about 15 per HOUR! We began last Wednesday and we are at 45% complete. But it does continue to move forward.

 

[kenhamady]

This sounds like it is running out of resources. It may not have enough ram, forcing it to swap to disk, which can take extra time. Have you tried it on a PC with more RAM? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)