Handling SQL Server 'Bit' values

[Eyespider]

Hi, We have a SQL Server 7 DB and it has certian values stored as the bit type.
I want to check if the value is false (i.e 0) and then carry out an action..
If {Db_Field} = 0 then do_action

When I try and execute the function i get an error saying 'A boolean is required'

I have tried putting the 0 in ""'s but the same error comes up. Using the word False (in ""'s and without) gives the error 'Number, Currency, Date or DateTime is required..

Does anyone know what is going on and how to get around it???

Thanks for any help you can give.

Regards
Simon.

 

[gregoriw]

Unfortunately, the BIT datatype is not recognized as one of the "standard" datatypes used in Crystal Reports. In my experience, I 've had to change the comparison expression to use the word 'TRUE' or 'FALSE' instead of 0 or 1. Also, to make it more fun, this doesn't necessarily work for different versions of Crystal (5,6,7,8). In V6 created RPT files, I've had to change the expression from False to 0 (or something like that) until the RPT would be satisfied with an expression it would be happy with.

I know it's not much help, but it does work.

WG