Print Page | Close Window

Suppress empty field's

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2865
Printed Date: 18 May 2024 at 4:23am


Topic: Suppress empty field's
Posted By: jskk
Subject: Suppress empty field's
Date 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.


Replies:
Posted By: jkwrpc
Date 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.
http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: jskk
Date 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.

Posted By: jskk
Date Posted: 15 Apr 2008 at 8:15am
stupid me, i simply forgot to check "suppress empty lines in embedded fields" in format-editor.


Print Page | Close Window