Collapsing blank lines in Reporting Services

Is there a way to collapse blank lines in Reporting Services? I have a
report where I stack contact information -- address, phone, email -- and some
records don't have one or another of these items. Rather than leaving blank
lines in between data, makin the report difficult to read, I would like to
collapse those lines and get rid of them. Is this possible? Using the
shrink/expand to fit data doesn't work.What's the container that the rows are in?
If you remove the space between the containers (textboxes?), that may be
what you are looking for. If not, you may need to go to a matrix or table.
"HHoward" <HHoward@.discussions.microsoft.com> wrote in message
news:6098B06F-686D-4EB1-ACC3-1D7B5F7BF08F@.microsoft.com...
> Is there a way to collapse blank lines in Reporting Services? I have a
> report where I stack contact information -- address, phone, email -- and
> some
> records don't have one or another of these items. Rather than leaving
> blank
> lines in between data, makin the report difficult to read, I would like to
> collapse those lines and get rid of them. Is this possible? Using the
> shrink/expand to fit data doesn't work.|||If the information is in a table and you have the value in a text box you can
click the left end of the line and in the visibility hidden you can put
=iif(len(Fields!Address.value)>0, false, true) Or you can just put a
condition on your data (iif(len(Fields!Address1.value)>0,
Fields!Address1.value & vbcrlf & Fields!Address2.value,"") Hope that makes
sense.
"HHoward" wrote:
> Is there a way to collapse blank lines in Reporting Services? I have a
> report where I stack contact information -- address, phone, email -- and some
> records don't have one or another of these items. Rather than leaving blank
> lines in between data, makin the report difficult to read, I would like to
> collapse those lines and get rid of them. Is this possible? Using the
> shrink/expand to fit data doesn't work.|||Great tip -- worked like a charm. Thanks so much!
"KimB" wrote:
> If the information is in a table and you have the value in a text box you can
> click the left end of the line and in the visibility hidden you can put
> =iif(len(Fields!Address.value)>0, false, true) Or you can just put a
> condition on your data (iif(len(Fields!Address1.value)>0,
> Fields!Address1.value & vbcrlf & Fields!Address2.value,"") Hope that makes
> sense.
> "HHoward" wrote:
> > Is there a way to collapse blank lines in Reporting Services? I have a
> > report where I stack contact information -- address, phone, email -- and some
> > records don't have one or another of these items. Rather than leaving blank
> > lines in between data, makin the report difficult to read, I would like to
> > collapse those lines and get rid of them. Is this possible? Using the
> > shrink/expand to fit data doesn't work.|||I'm glad that it worked for you!
"HHoward" wrote:
> Great tip -- worked like a charm. Thanks so much!
> "KimB" wrote:
> > If the information is in a table and you have the value in a text box you can
> > click the left end of the line and in the visibility hidden you can put
> > =iif(len(Fields!Address.value)>0, false, true) Or you can just put a
> > condition on your data (iif(len(Fields!Address1.value)>0,
> > Fields!Address1.value & vbcrlf & Fields!Address2.value,"") Hope that makes
> > sense.
> >
> > "HHoward" wrote:
> >
> > > Is there a way to collapse blank lines in Reporting Services? I have a
> > > report where I stack contact information -- address, phone, email -- and some
> > > records don't have one or another of these items. Rather than leaving blank
> > > lines in between data, makin the report difficult to read, I would like to
> > > collapse those lines and get rid of them. Is this possible? Using the
> > > shrink/expand to fit data doesn't work.