Walter Meester
HoogkarspelNetherlands
General information
Category:
Third party products
>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 ?
Yes. Users are able to run these reports without launching the VFP application. Also, it allows them to make a copy of the report and change it to their heart's desire.
>B.t.w. Did you have a look at the SQL designer ??
Yea. One thing that I failed to mention was that the two tables that I'm trying to use come from different ODBC data sources. From what I can tell, and I hope that I'm wrong, is that you can't use more than one data source in a given query file.
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only