cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete a blank line in the Address formats Printlayoutdesigner

Former Member
0 Kudos

Hello,

I made the following address formats definition:

Administration -> Definition -> Businesspartnersr -> Adress formats:

ADRESS-ZEILE 2

ADRESS-ZEILE 3

GEBÄUDE

STRAßE

PLZ " " STADT

A couple of businesspartners did'nt have an entry in ADDRESS-ZEILE 3 field. So if a report is printed in Printlayoutdesigner, ther is a blank line.

Example:

Mr.

Marvin Müller

Mainstreet 1

11111 Town

How can i delete this blank line?

many thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

To suppress blank lines in an address in PLD:

Step 1: Create a text field with a line-feed character in it

Content: XX where is the enter key

(PLD won't retain any leading or trailing white-space -- spaces, linefeeds, etc -- so we need to use the "X"s )

Change the unique ID to "LF"

Uncheck 'Visible'

Step 2: Change the Unique ID of the address field to be "Addr"

Step 3: Create a formula field with the following:

Concat(

Sentence(Addr,1),

Substring(LF,1,2),

Sentence(Addr,2),

Substring(LF,1,1+(Sentence(Addr,2) != "")),

Sentence(Addr,3),

Substring(LF,1,1+(Sentence(Addr,3) != "")),

Sentence(Addr,4)

)

Former Member
0 Kudos

Hi,

PLD is a basic printing tool that has limited function available. There is no way to omit blank line. If two lines are not very long in length, you may combine them in one line.

Thanks,

Gordon