Post reply

Preventing a row from displaying

  • December 4, 2006 at 2:47 am

    #171484

    I'm trying to create a report and have most of it down.  The problem lies in trying to keep a row from displaying if a field contains a particular value.  The underlying table has a column called DrawingType, defined as char(2), and I don't want to display any rows from that table if the DrawingType field for that row contains "ND".  I've tried using -- Iif(Fields!DrawingType.Value = "ND", "", Fields!DrawingDescription.Value) -- but it doesn't seem to have any effect on whether or not the row is displayed.  Is there another method to accomplish what I'm trying to do?

  • December 4, 2006 at 3:40 am

    #675406

    I finally figured it out .  I highlighted the row in the table, went to the Properties sheet and selected Grouping by clicking on the ellipsis.  I grouped on the row ID under the General tab and then selected the Visibility tab.  For Initial Visibility, I selected the Expression radio button and typed in the following expression:

    =iif(Left(Fields!DrawingType.Value, 2) = "ND", true, false)

    Works like a charm!

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

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