How to apply only OR filter opertor on more than one columns

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  January 10, 2011 at 7:13 am

  #1271369

  What is it you want returned?

  >=19, True

  Mother, True

  Father, True

  All others false?

  If this is what you want, try this:

  =IIF(cstr(Fields!AGE.Value) >= 19,"true",IIF(cstr(Fields!Position.Value) = "Mother","true",IIF(cstr(Fields!Position.Value) = "Father","true","false")))

• azhar rahi

  Valued Member

  Points: 54

  More actions

  January 10, 2011 at 7:50 am

  #1271401

  I have already resolved it. It was very simple. Thanks by the way.

• Jeff Moden

  SSC Guru

  Points: 1004664

  More actions

  January 10, 2011 at 7:58 am

  #1271405

  azhar rahi (1/10/2011)

  ---

  I have already resolved it. It was very simple. Thanks by the way.

  How did you resolve it?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)