I've been stumbling on this for too long and need some help. I'm very new to Sql Reporting Services .. 1 day actually doing anything with it.

Add1 = "120 Main St."
Add2 = ""
Add3 = ""
City = "City"
State = "ST"
ZIP = "11111"

I need it to show up as:

121 Main St.
City, ST 11111

I'm having problems removing the blank Add2 and Add2.

I'm sure this is very simple to do, could someone please explain it to me.

Thanks,

- Vince

Hello and good luck with the Reporting Services

I have a mail label report that has to do this also, so i would combine the add1, add2 and add1 into the one field/textbox and use the following expression:

=Fields!Add1.Value & iif(Fields!Add2.Value = "" ,"", vbcrlf) & iif(Fields!Add2.Value = "" ,"", Fields!Add2.Value) & iif(Fields!Add3.Value = "" ,"", vbcrlf ) & iif(Fields!Add3.Value = "" ,"", Fields!add3.Value)

This will always show (not supress add1, but suppress add2 and/or add3 is blank)

And you should be able to work out how to do the second line.

Hope this helps

Blowinoil