Dynamically removing table rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry - 28 Sep 2005 19:10 GMT

How can I dynamically remove a table row if a value is blank?

(i.e. Address 2 is blank)

Reply to this Message

Robert Bruckner [MSFT] - 28 Sep 2005 21:32 GMT

If you select the entire table row in report designer, you will notice that
there is a Visibility.Hidden property for the table row. You can use an
expression that evaluates to a boolean value to dynamically hide a table row
then. E.g. =IsNothing(Fields!Address2.Value)

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> How can I dynamically remove a table row if a value is blank?
>
> (i.e. Address 2 is blank)

Reply to this Message

Terry - 29 Sep 2005 13:12 GMT

Thank you.

However, I tried on several occasions to get help with columns and no one is
able to assist.

Could someone provide me with a basic understanding how to setup columns?

The columns will be used for mailing labels.

Your assistance is greatly appreciated.

> If you select the entire table row in report designer, you will notice that
> there is a Visibility.Hidden property for the table row. You can use an
[quoted text clipped - 7 lines]
> >
> > (i.e. Address 2 is blank)

Reply to this Message

Robert Bruckner [MSFT] - 30 Sep 2005 05:59 GMT

Not sure I understand your follow up question correctly. Are you asking
about dynamically hiding table columns in a report? Table columns have a
visibility property like table rows.

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Thank you.
>
[quoted text clipped - 22 lines]
>> >
>> > (i.e. Address 2 is blank)

Reply to this Message

Terry - 30 Sep 2005 12:43 GMT

Dynamically removing table rows have been resolved.

Thank you for your assistance.

> Not sure I understand your follow up question correctly. Are you asking
> about dynamically hiding table columns in a report? Table columns have a
[quoted text clipped - 29 lines]
> >> >
> >> > (i.e. Address 2 is blank)

Reply to this Message