>Hi - I am using Crystal Reports and VFP6 for the first time and I trying to report on records where a certain field is a logical true.
>
>I set the report up but got no records back - I looked at the SQL and found that it was filtering on myField = 1
>
>Is there any way to correct this?
>
>I have found the fields tab on and have played with the settings for Boolean but with no success
Maybe I'm just using it different. I save the file that Cyrstal is going to use for the report as Fox2x. When I have a logical, the selections are True or False or Formula. True just leaves the tablename.field name in the { } brackets.
How are you accessing the data?
Tracy