sql server reporting services: comparision filter on a float field -- sql server reporting services

comparision filter on a float field

marg
10/23/2006 11:15:02 AM

sql server reporting services:

I'm trying to do a comparision filter on a float field and I keep getting the
error

[quoted text, click to view]

I keep getting the error 'check data type returned'. I tried
[quoted text, click to view]
but this did not work either.

Any ideas

RE: comparision filter on a float field

Stefoon23
10/25/2006 5:17:01 AM

Hi 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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.