Using full outer join in CR10 1

[nealkay]

I'm trying to report out from two tables - a time clock table and a sales activity table. The challenge is that (1) sales can be made without clocking in and (2) some times those who clock-in make no sales. The full outer join looks like the right way to collect all possibilities, but the 'full outer join' button is grayed out in the Database Expert Link Options window. Any suggestions greatly appreciated. Thanks

 

[Turkbear]

Hi,
The options are database dependant..Does the database ( unspecified) that you use support full outer joins?

 

[nealkay]

Thanks, Turkbear - that makes sense. I'm pulling the tables from a point-of-sale system written in Visual FoxPro 7.0. VFP supports full outer joins. Is there any way to force implemenatation?

Neal

 

[Turkbear]

Hi,
One more question - are all the tables from the same data source, using the same driver? Some linking options are not enabled when multiple datasources/drivers are used.

You could try to manually edit the Sql produced( using the Show Sql Query option) to set the join type..Not sure of the VFP syntax for that, however.

 

[nealkay]

Thanks Turkbear. The tables are from a single database using the built-in Windows/VFP ODBC driver. I'll try modifying the SQL code tonight.

 

[Turkbear]

Hi,
Since I do not use VFP, I don't know for sure, but is there a Crystal-supplied ODBC driver for VFP?
If so, use it instead of the Microsoft one and see if it helps..