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 message for this, The value expression for the textbox mmActDate contains an error: Argument 'Month' is not a valid value. thanks.

Try isnull function instead? =IIF(isnull(Fields!mmactdate.value,'01/01/1900')='01/01/1900',.... or something to that effect? (not sure about date format in your db.) Here's more info on the switch functionality, but you may want to just investigate custom code & a function if you're getting too complex. cheers, Andrew

Try this instead:=MonthName(iif(IsNothing(Fields!mmActDate.Value), Fields!mmPlanDate.Value, Fields!mmActDate.Value))-- Robert

The following worked for me ...= IIF(Fields!Desk.Value is NOTHING, 0, Fields!Desk.Value)The 0 (zero) is the true value, followed by the false value.

Thanks Craig. This solution helped me!

I noticed everyone gave answers, but none ever gave examples on the SWITCH expression here is what I found in BOL.=Switch(Fields!PctComplete.Value >= .8, "Green", Fields!PctComplete.Value >= .5, "Amber", Fields!PctComplete.Value < .5, "Red")

This worked like a charm, thanks Robert!