This was interesting. Regardless of where I introduced a conversion function within the expression it created an error for the non-numeric entries. This is a little different approach,...

Scott,

Thanks that would work, but our users want this capability on the fly. I haven't seen anything that leads me we can do that from the report definition.

We are...

I am assuming the Acct field is an integer here.

= IIF(Fields!Acct.Value = 5200,"Regular Hours",IIF(Fields!Acct.Value = 5204,"Overtime Hours","Whatever you want if it isn't either"))

I would try using the decimal conversion on only the numeric values.

=AVG(IIf(Fields!SCORE.Value = "Unknown", Nothing, CDec(Fields!SCORE.Value)))

I think converting "Nothing" to a decimal creates the zeroes that are causing the problems.

Restarting SQLServer works for me. We are using SQL Server 2005.

oops....I meant to use the CONVERT function

Are the fields ActsDate and ItemDate both varchar datatype in the original data source? If so, maybe this will work for you.

=IIF(DateDiff("m", CONVERT(Fields!ActsDate.Value, datetime),...

Are the fields ActsDate and ItemDate both varchar datatype in the original data source? If so, maybe this will work for you.

=IIF(DateDiff("m", CAST(Fields!ActsDate.Value, datetime), CAST(Fields!ItemDate.Value, datetime))>=6,"Red","Black")

Try the following modification to the Switch statment (changed the arithmetic operators)

=Switch(DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))>6,"Red",DateDiff("m",CDate(Fields!ActsDate.Value),CDate(Fields!DecisionDate.Value))<=6,"Black")