Using iif to set the colour in an SSRS2005 report (code below) I get this error: [rsCompilerErrorInExpressi
on] The Color expression for the textbox ‘AvgHours’ contains an error: [BC30452] Operator '<=' is not defined for types 'Microsoft.ReportingServic
eld' and 'Double'. I assume RS is inferring the type double as entering other values results in the same error but with integer or string as the type.
Thanks for any help,
=iif(Fields!Group.Value <> "" and Fields!AvgHours.Value >= 8.4,
iif(Fields!Group.Value <> "" and Fields!AvgHours.Value >= 8 and Fields!AvgHours <= 8.3,
iif(Fields!Group.Value <> "" and Fields!AvgHours.Value <= 8,