Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crystal Reports Freezes Post Reply Post New Topic
Author Message
Omprakashkarry
Newbie
Newbie


Joined: 24 Jan 2013
Online Status: Offline
Posts: 6
Quote Omprakashkarry Replybullet Topic: Crystal Reports Freezes
     Posted: 17 Jul 2013 at 5:39am
Hi,
 
I wanted to edit a condition in one of the crystal reports.
 
So, I went in to the formula editor and edited the formula and when I tried to refresh the report, the report has stopped functioning properly. It looks like it is loading all the data from the database without considering the conditions applied in the formula editor.
 
can any one please letme know how to get around this issue?
 
Any reason why this is happening?
 
Thanks
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 17 Jul 2013 at 6:04am
Hi,
 
Apply(edit) the condition on saved data.
Are you applying it in selection formulas or formulas which are in Formula fields.
if Possible paste the formula in this thread..
After refreshing the report,  Left bottom corner of designer what it is dispalying?(Accessing database/ Reading records.....)
 
-Praveen G
 
 
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jul 2013 at 6:12am
Just a guess but you might have have enforced a previously not enforced join (or cross join) by using a field in the formula from a table that previously had no fields being used.
It appears to freeze because it changed the data set. If it enforced a cross join it may end up creating millions of rows in the set.
IP IP Logged
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