Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: out of memory Post Reply Post New Topic
Author Message
JohnNash
Newbie
Newbie
Avatar

Joined: 10 Jan 2012
Online Status: Offline
Posts: 11
Quote JohnNash Replybullet Topic: out of memory
    Posted: 22 Jan 2012 at 10:27pm
Hi,
 
I am using crystal reports XI and getting out of memory error for some of the times, using 6 tables with left outer join, tried my level best by changing group/join/indexes, please advise if any one come across the same.
 
Thanks in advance
 
Regards
John
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3628
Quote hilfy Replybullet Posted: 23 Jan 2012 at 6:07am
How much data are you pulling?  What type of database are you connecting to?  Are you using any formulas in the selection criteria or sort/group that would cause Crystal to pull everything into memory before filtering/sorting instead of pushing that task to the database?
 
Crystal does a LOT of swapping to disk when it is processing a report and it's not always very good about cleaning up after itself.  You need to go to your temp folder and delete all of the files that start with "~" - these are Crystal's temp files.
 
-Dell
Proviti, Data & Analytics Practice
9-Time SAP BusinessObjects Partner of the Year.
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
JohnNash
Newbie
Newbie
Avatar

Joined: 10 Jan 2012
Online Status: Offline
Posts: 11
Quote JohnNash Replybullet Posted: 23 Jan 2012 at 9:51pm
I am connecting to Sql server 2008, not using any selection formulaes but i have 6 sub reports in my report, displaying summary values for different investors, for some of the investors the result is coming up but for few of them ending up with out of memory error.
 
Thanks for the reply
 
John
IP IP Logged
JohnNash
Newbie
Newbie
Avatar

Joined: 10 Jan 2012
Online Status: Offline
Posts: 11
Quote JohnNash Replybullet Posted: 25 Jan 2012 at 3:57am
hi hilfy,
 
may i know do we have any updates on this out of memory?
 
 
Thanks in advance
 
 
John
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.047 seconds.