Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Field skips a page Post Reply Post New Topic
Author Message
bremen
Groupie
Groupie
Avatar

Joined: 28 May 2013
Online Status: Offline
Posts: 93
Quote bremen Replybullet Topic: Field skips a page
     Posted: 24 Jun 2013 at 7:34am
I have a field in Group Header A that seems to skip a page.  It prints on pages 1,2, and 4 but for some reason skips page 3.  I cant seem to figure out why it would skip a page. 
 
THe data on page 2 is very similar to the data on page 3 with only minor differencesa that would no effect the field not printing on page 3.
 
any ideas?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Jun 2013 at 8:42am
Is this the third page of a single group or is your report showing one group per page?  If page 3 is not the same group value as page 2, odds are that the field in question does not have a value for the group on page 3.  To test this you can do something like this:
 
1.  Create a new formula that will do something like the following:
 
If IsNull({field that is blank}) then "Null Field"
else if ltrim(rtrim({field that is blank})) = "" then "Field is blank"
else {field that is blank}
 
Put this on the report instead of the actual field.  This will show you whether there is data in the field or not.  (NOTE:  NULL is NOT the same as a blank string!  That's why you have to test for the separate conditions.)
 
-Dell
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