supress blank field in label report

[Chuck712]

I have been searching for an answer of this. I have an Avery 5160 label report that in SSRS where I have a field for address line 2 that for the most part returns nothing. I have to create a field for it if there is something in the field, but unlike Crystal, you can't simply supress the field and have all the lines move up. Like this:

Anyname Jones
1234 Mainstreet
Suite 50
Anytown, ST 51263

Someone Else
6658 Maple
Anytone, ST 51263

Instead you get:

Someone Else
6658 Maple

Antone, ST 51263
I have tried to use an expression to hide the field. Everything from IsNothing, to IIf
The line still remains.

I haven't found anything anywhere that address's this.

 

[SgtJarrow]

Instead of separate boxes, use one and create the name in the source:

=NameField & vbCrLf & Address1Field & vbCrLf & IIF(LEN(Address2Field) > 0, Address2Field & vbCrLf, "") & CityField & ", " & StateField & "  " & ZipCodeField

Typed, not tested....

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[Chuck712]

Thanks. That is closer. Perhaps a little tweaking. I am getting some over runs.


B.R Somebody
2780 Ne 1556th St Apt 91
45 GreatBeach
,FL 30000-9000
Of course trying to make sure that I have the text box sized right for the label could also be an issue. I will work with this.