Print Page | Close Window

Export to Excel Performance

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7407
Printed Date: 07 May 2024 at 5:26am


Topic: Export to Excel Performance
Posted By: alanh12
Subject: Export to Excel Performance
Date Posted: 18 Aug 2009 at 5:13am
Hello,
 
We have a Crystal Report that runs in 8 minutes that takes 2 1/2 hours to export to Excel.  We feel we must be doing something wrong or we have a configuration issue.
 
Has anyone else experienced such problems, and if so, what is your recommedation for solving the problem?


-------------
Alan H


Replies:
Posted By: Allany
Date Posted: 18 Aug 2009 at 8:12am
how large is the data set being returned?  I believe the crystal client needs to store the data in memory before being returned.

Posted By: alanh12
Date Posted: 18 Aug 2009 at 8:21am
It is a large amount of data.  Approximately 21,000 rows by 18 columns.
 
The report shows on the screen quickly, 8 minutes. What we don't understand is why should memory cause the export to Excel to take 150 minutes ( 2/12 hours).
 
Thanks for your help.
 
Alan


-------------
Alan H


Print Page | Close Window