Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: If Fields Blank Move Record(s) Below Up Post Reply Post New Topic
Author Message
jsh8286
Groupie
Groupie
Avatar

Joined: 09 Mar 2012
Online Status: Offline
Posts: 46
Quote jsh8286 Replybullet Topic: If Fields Blank Move Record(s) Below Up
     Posted: 11 Jun 2013 at 2:11pm
As the subject indicates have a crystal report where I want to be able to move records up if the above record is blank above.
 
For example:
 
In a credit note for example I want to display some address information lide this:
 
Ship To Name
Ship To Address 1
Ship To Address 2
Ship To Address 3
Ship To Address 4
City, State, Zip
 
Now in a perfect world if the data is filled in all the above fields there is not issue. But depending on the customer in many instances Address lines 2, 3 and 4 sometimes are not applicable hence there is no information in them.
 
So when the credit note prints (this assumes in this example address lines 3 and 4 are blank) I get back the following:
 
Ship To Name
Ship To Address 1
Ship To Address 2
 
 
City, State, Zip
 
There are two blank lines. What I want is:
 
Ship To Name
Ship To Address 1
Ship To Address 2
City, State, Zip
 
So in this case since the above two lines returned a blank the City, State, Zip field moved up two spaces.
 
Any suggestions?
 
Thanks in advance.
IP IP Logged
manjucrystal
Newbie
Newbie


Joined: 11 Feb 2013
Location: India
Online Status: Offline
Posts: 13
Quote manjucrystal Replybullet Posted: 11 Jun 2013 at 6:34pm
Please use separate sections for all fields and enable the check box option in section expert -> suppress blank section.
 
Hope this will solve ur issue.
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