Doug,

Is there any particular reason why you don't prepare your data in VFP, copy it to a FOX2x Table and use that on in your Crystal Report ?

B.t.w. Did you have a look at the SQL designer ??

Walter,



>Hey all. I have a need to perform the old SELECT WHERE NOT IN sub-select from within Crystal Reports.
>
>In VFP it's just:
>
>SELECT x ;
> FROM table1 ;
> WHERE table1.x NOT IN ;
> (SELECT table2.y FROM table2)
>
>Any clues on how to accomplish this with CR?
>
>Thanks.