Format Customer Addresses

[sgk17]

I am working on a customer invoice report that needs to print out the billing and shipping address as part of the report. Each address contains 8 fields: Name, Attention, Address1, Address2, City, State, Zip, & Country.
I am pulling each field from the database. Most of the time the Attention and Address2 fields are blank. Is there a nice way to display these addresses without leaving a blank line when the fields are empty? Here's an example of what I'm getting:

BILL TO: Joe Mama (Name)
(Attention)
1558 N American Way (Address1)
(Address2)
Payson, CA 86214 USA
If the Attention field is blank I would like it to show as:

BILL TO: Joe Mama
1558 N American Way
Payson, CA 86214 USA

Thanks for the help.

 

[checkai]

Drop them in a text field the way you want them to look and then choose the option to suppress blank lines ( i think) should make it look the way you want it!

DLC

 

[checkai]

Suppress Embedded Field Blank Lines Option is what you want....sorry for the 1st hasty reply

dlc

 

[sgk17]

Thank you. That did work like I wanted.