How to suppress address lines that's NULL/empty in PLD
I would like to print the full address of the BP in my layout.. However, some BP have 3 address lines, some have 2, and some have 4.
How do I suppress those empty address line in layout, so that it won't display BLANK line in my print layout? Because at the last line, I will display the country and zip code. Therefore I don't want BLANK lines in between.
Example in layout:
Address line 1
Address line 2
Address line 3
Address line 4
Country & Zip code
Edited by: Paul Finneran on Oct 9, 2008 2:55 PM
Andrew Flynn replied
The only way to remove the blank lines is if the actual BP address does not have any empty values e.g. if a customer has 4 lines in his address then you use the first 4 fields on the BP Master screen.
In my opinion this is not a solution at all since you really need to assign address values to their relevant address fields.
The last time I checked it was not possible to remove blank address lines on the PLD using forumlae etc. This has been a problem with SAP PLDs from day one.
Ofcourse if you were to design your layout using Crystal then there's no problem, a simlple formula using mutiple IF statements can be used to remove any empty values.