Hi All,

I am trying to create a simple report via ODBC to a Visual Foxpro Database.
I have a simple table, Field1 Char(10), and Field2 Logical. No Index or
anything..

I do a Crystal Report (Version 8.5, 9 & 10) and connect to the
Database Via ODBC. I then place in the Record Selection portion
of Crystal {mytable.field1} = true...

This then causes Crystal to Yack and tell me that it is a
Operator / Operand Mismatch. I see the SQL Statement trying to
pass a '1' as the field value..

I'd really like to stick with ODBC as this is the most simple
example where this is failing...

Can anyone please help me out with the workaround to this??

Thanx!
Bob