Suppressing Lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JustMe - 30 Mar 2006 23:00 GMT

I have a report where the information is not always filled in so I want to
supppress the blank lines. For example if you have Address 1 and Address 2.
If you do not have information in Address 2, I want the city, state and Zip
to move up a line..
So if I have both Add1 and Add2 it would look like this...
123 Main Street
Apt 3
City Name, St, zip
(###) ###-####

If I only have one address it would look like this...
123 Main Street
City Name, St, zip
(###) ###-####

I can use the following to accomplish this
=iif(Fields!Add2.Value = "0", fields!Add2.Value, fields!CityStateZip.Value)

Now my problem is what if both field Add2 and CityStateZip or blank? I want
it to look like
123 Main Street
(###) ###-####

Can I just add to the inline statement, if so, how?

Reply to this Message

GORAMS - 31 Mar 2006 15:18 GMT

I had a similar situation where there were two fields that could be blank and
I had to put an IIF inside an IIF on each textbox that needed to be moved up.
Here is an example of my code from one of the text boxes. Keep in mind that
your field names are going to change per text box.

Hope it helps.

=IIF(Fields!SADD1.Value = "0", IIF(Fields!SHIPTEXT.Value = "0", "CONTACT:" &
Fields!CONTACT.Value, "SHIPTEXT:" & Fields!SHIPTEXT.Value),
Fields!SCITY.Value)

Reply to this Message