Hi Pauline,

I have seen a similar problem using numeric indexes. When we changed to use the VFPOleDB as the connection, instead of the native fox2x, the problem went away. Crystal told us they were going to fix the problem in Version 10.

Tracy

>Hi,
>
>I am having a problem selecting records in Crystal reports (Version 9.2) using Visual Foxpro data (Version 7.0) where the selection criteria uses a logical field that is contained in the CDX (index file).
>
>As an example, I have a simple VFP DBC containing one DBF file, called table1. This DBF contains 2 fields :-
> KNOWN_AS c(30)
> ISACTIVE Logical
>
>The CDX file contains 2 index tags - one for each field.
>My Crystal report could not be more simple - it just shows both fields.
>
>My problem is that if I preview the report, with a selection Criteria of table1.isactive 'is True' (or {table1.isactive} if viewed in the Formula Editor), I get no records displayed even although there are some. NB - same results for 'is False'.
>
>As a work around for this problem, if I remove the 'isactive' tag from the CDX then the selection criteria works as expected. Also, if I go into File->Report Options and uncheck the option "Uses Indexes or Server for Speed" then I get the correct results.
>
>The problem is that alothough I have a work around for the problem it is not an acceptable one to offer to my users. In our actual data we have quite a number of logicals which are indexed, so they cannot easily be removed. Also, I am reluctant to uncheck the "Uses Indexes or Server for Speed" as this would cause all reports to run slower.
>
>Has anyone else had this problem? Does anyone know of a fix?
>
>Thanks in advance,
>Pauline Pearce