Post reply

Table Properties Filter Problem

  • August 12, 2008 at 7:43 am

    #189196

    Hi all,

    When I go to table properties (right click table and properties) I select the Filters tab, when I enter an expersion its operator and then value and then enter another row benenth for the AND/OR tab stays AND all the time, is it possible for me to change this to an OR (it wont allow me to )

    Thanks

  • August 13, 2008 at 5:07 am

    #857284

    Hi,

    It will select AND automatically if you need to add filter on another field. If you are adding filter on same field then it will select OR.

    e.g. filter on fields!total = 1 or filelds!total = 2 or fields!total = 3

    e.g filter on fields!toal = 1 and fields!name = 'V' and fields!lastname = 'D'

    Hope it helps.

  • August 14, 2008 at 3:32 am

    #857908

    If you really need to filter on the table and cannot handle it in a dataset, you could use a filter expression, for example

    =IIF(Fields!Field1.Value="A" OR Fields!Field2.Value="B","show","filter")

    set the Operator to =

    and Value to show

  • August 14, 2008 at 5:01 am

    #857950

    Thanks for both replies...it is only possible to do the OR if its the same field-that makes sense, thanks.

    Thanks for the example with expression, i will use that for my solution.

Viewing 4 posts - 1 through 3 (of 3 total)

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