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.
Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
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.
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.
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
IP Logged
