Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Export to Excel Performance Post Reply Post New Topic
Author Message
alanh12
Newbie
Newbie


Joined: 18 Aug 2009
Location: United States
Online Status: Offline
Posts: 2
Quote alanh12 Replybullet Topic: Export to Excel Performance
    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
IP IP Logged
Allany
Newbie
Newbie


Joined: 03 Aug 2009
Online Status: Offline
Posts: 12
Quote Allany Replybullet 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.
IP IP Logged
alanh12
Newbie
Newbie


Joined: 18 Aug 2009
Location: United States
Online Status: Offline
Posts: 2
Quote alanh12 Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.