Logical/Boolean Field from Vfp

Hi Members!

I have developed an application. And main database is made in Vfp and using ODBC I connect in VB and Crystal reporting.

I have a table Fields who's type is Logical/Boolean. I used the RecordSelectionFormula that to view all records who are True in Logical/Boolean field..But I am facing an Error.

This is my statement:

Report.RecordSelectionFormula = "{Table.Field} = 'String' AND {Table.Field}=True"

Kindly help me
Thanx in Advance

I don't remember how FoxPro handles bitwise values, but try 0 or 1 for your true/false conditions. And is 'string' a hard coded string or a string variable being passed into the statement.

Also, what is the error your receive? And can you post your entire Crystal Report code so we can see if there are any other potential errors.