Table Help

  • Ok new to all this programming stuff. 

    Have a field from db of "location" (which has addresses in it).  I need to display this in the table.  No

    problem there just drag the field name in and walla.  But in some instances

    the value contained in the db is "Value Unknown" and when this is the case I

    wish the table cell to contain nothing.

    How do I do this?  Is it with an expression on the format property of the

    cell of the table.

    Any help on this would be greatly appreciated.

  • You can use an iif statement to change the value in the table, for example:

    =iif(Fields!location.value = "Value Unknown", "", Fields!location.Value)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply