I'm trying to do a comparision filter on a float field and I keep getting the
error
> Expression =Fields!float_cal.Value
> Operator <= > Value =0
I keep getting the error 'check data type returned'. I tried
> Expression =CInt(Fields!float_cal.Value )
but this did not work either.
Any ideasHi Marg,
if it is a float field you should convert it to double, not integer.
Try Expression = Cdbl(Fields!float_cal.Value ).
If that does not work you could even try cdbl(Expression) =Cdbl(Fields!float_cal.Value ).
Best regards,
Stefan
"marg" wrote:
> I'm trying to do a comparision filter on a float field and I keep getting the
> error
> > Expression =Fields!float_cal.Value
> > Operator <=> > Value =0
> I keep getting the error 'check data type returned'. I tried
> > Expression =CInt(Fields!float_cal.Value )
> but this did not work either.
> Any ideas
>
Friday, February 10, 2012
comparision filter on a float field
Labels:
comparision,
database,
error,
expression,
field,
fieldsfloat_cal,
filter,
float,
microsoft,
mysql,
operator,
oracle,
server,
sql,
value
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment