Crystal Reports Large Data problem

Writing Code
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code

Topic: Large Data problem

Author	Message
mmyaseen Newbie Joined: 15 Jun 2009 Location: India Online Status: Offline Posts: 1	Topic: Large Data problem Posted: 18 Jun 2009 at 3:48am
	I have data of around 5 million records, when i bind the data to crystal reports it takes around 5-10 mins. When i export the crystal report gives out of memory exception. Also when i do paging the paging is very very slow. I am working on crystal report in .NET Framework 2.0 (VS.NET 2005). Anybody has solution for this
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 23 Jun 2009 at 6:46am
	How long is your report...a million pages (ok, I exaggerate) but that is a LOT of data. Remember that Crystal reads the data like 3 times and that it has to fetch the data from the DB, fetching that much data is going to take a bit. I would have thought that paging would be quicker, but there is a lot of data for Crystal to keep track of. Are you binding to the tables are you fetching via a stored proc? If from a stored proc, how long does it take to complete. Then probably double that to get the 'run' time for Crystal...seems to work as a rule of thumb for me...if it takes 10 seconds to run in SQL server, then it will seem to take 20 for Crystal, maybe longer. Regardless, it seems that that is an awful lot of data to push to a report...do you need them all? Maybe you don't, maybe you do. Maybe you can do some preprocessing on it in the DB so that fewer records are needed. HTH
	IP Logged

bradcapo1 Newbie Joined: 21 Jul 2009 Location: Afghanistan Online Status: Offline Posts: 1	Posted: 21 Jul 2009 at 2:49am
	I am not so knowledgeable about this matter. So i have to learn it. Thanks for the post. taux pret auto[/color"> - taux pret auto differe selon la rise en compte ... calculent automatiquement le taux pour un prêt automobile donne.
	IP Logged

Rupali Newbie Joined: 21 Jul 2009 Online Status: Offline Posts: 2	Posted: 21 Jul 2009 at 3:20am
	Hi, How about fetching the data in slabs of 50 records dynamically ? Let me explain: If you implement the paging control through code you can fetch the data only when required. On an average the Crystal report displays 50 records/page (varies according to the font). So if you do this, you will be able to fetch the data dynamically in slabs of 50 records. This ways, the Usability of your report increases as the user need not ponder at the screen for long. Hope this servers the purpose. Cheers , Rupali
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 21 Jul 2009 at 6:08am
	How would you implement this? It's a great solution, but I have never seen this done for Crystal. How would Crystal know how to group the data, as it doesn't have all the data to begin with? Please share. Thanks
	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.047 seconds.