Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Weird data loss issue... Post Reply Post New Topic
Author Message
johnnycanEHdian
Newbie
Newbie


Joined: 04 Jun 2010
Location: Canada
Online Status: Offline
Posts: 1
Quote johnnycanEHdian Replybullet Topic: Weird data loss issue...
    Posted: 04 Jun 2010 at 7:33am
I have a report created that usually fits on one page. When it is on one page it works fine, however, when i have enough detail rows to cause the report to span 2 pages, the report breaks.
 
The issue is one of the fields in the header no longer has a value. On page 1, the value is there, page 2 it's missing. This value is used in other formula fields which in turn break because the value is missing.
 
Has anyone seen this before and/or know how i can correct it? All other values are showing on both pages... it seems to be specific to this one field.
 
Thanks in advance.
 
John
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 09 Jun 2010 at 2:53am
You could assign the value to a global variable, and then access the global variable in the formula instead of the field value...something like:
 
global numbervar x;
if not isnull({table.field}) then
  x := {table.field};
 
y=x + 27 (rest of formula)
 
HTH
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.