Switch / Choose in Expressions

• girija-265903

  SSC-Addicted

  Points: 436

  More actions

  October 5, 2005 at 12:43 pm

  #111087

  Can someone give some examples for Switch and choose Statements to use in Expression like IIf. thanks.

  also i need to know how to check for the null value. IsNothing and IS System.DBNull.Value doesn't seem to work.

  =IIf( Fields!mmActDate.Value IS System.DBNull.Value, MonthName( Fields!mmPlanDate.Value ),MonthName( Fields!mmActDate.Value ))

  I get a warning meesage for this,

  The value expression for the textbox ‘mmActDate’ contains an error: Argument 'Month' is not a valid value.

  thanks.

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  October 5, 2005 at 5:47 pm

  #595314

  This earlier post has details on how to use IsNothing() and also the switch statement (scroll down to the reply from pg53).

  Steve.