Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Suppress empty field's Post Reply Post New Topic
Author Message
jskk
Newbie
Newbie


Joined: 08 Apr 2008
Online Status: Offline
Posts: 3
Quote jskk Replybullet Topic: Suppress empty field's
    Posted: 09 Apr 2008 at 6:48am
In my report I am showing business clients' addresses like this:

CompanyName
FamilyName Prename
Street
ZIPCode City

Now there are many cases where no familyname and prename are stored in the database. In this case an empty line is showing up in the report. But I want this empty line to be suppressed/not seen, cause it doesn't look to good.
How can I do that?

I tried to enter a formula in the formatting-window, that suppresses the line, when no name is stored, but still an empty space is appearing between CompanyName and Street.

IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 09 Apr 2008 at 12:54pm
Try creating a text box and then placing the data fields inside it. If the fields are empty they should not show.  I know this works for multi-line addresses and presume it will work the same here.
 
Regards,
 
John W.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 11 Apr 2008 at 2:49pm
The other way to do this is to put each of your lines in a separate section and turn on "Suppress if Blank"
 
-Dell
IP IP Logged
jskk
Newbie
Newbie


Joined: 08 Apr 2008
Online Status: Offline
Posts: 3
Quote jskk Replybullet Posted: 15 Apr 2008 at 5:35am
thanks for your suggestions.
i used a textfield and inserted the datafields into that textfield, but when the datafield is empty (null) there is an empty line.
so, it's the separete section now.
IP IP Logged
jskk
Newbie
Newbie


Joined: 08 Apr 2008
Online Status: Offline
Posts: 3
Quote jskk Replybullet Posted: 15 Apr 2008 at 8:15am
stupid me, i simply forgot to check "suppress empty lines in embedded fields" in format-editor.
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.