Full Outer Join 2

[BurnsORegan]

Has anyone come accross the Full Outer Join button being greyed out even though the join is possible. I am on a client site and have an issue that appear to be the Full Outer Join facility is permanently greyed out!

Help

Regards BurnsORegan

 

[pgtek]

hi
check this

http://support.businessobjects.com/...TICALDISPLAY.CONTENTTYPE.FILESIZE&num=&start=

cheers



pgtek

 

[BurnsORegan]

pgtek

Thanks for the reference I had already seen that, the issue is that the paper refers to the Stored Procedures options which should have no bearing on the Full Outer Join!

The paper also goes on to say that only the Inner and Left Outer should should work unless using Stored Procedures which again is not true. The Right outer is also an option.

So currently I am back at step 2.

Regards

Burnsoregan

 

[kenhamady]

What is your database platform. Are you sure that it supports FOJ through ODBC?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[BurnsORegan]

kenhamady

Thanks for your response. I am not sure were to check the support features of the ODBC driver, do you have any suggestions. I have also tried to install the Crystal Reports on a stand alone machine running JDE 5 and it seems to do the same thing..(not work)

Any suggestions?

Regards

BurnsORegan

 

[kenhamady]

It is probably not supported in JDE. You would need to check with the people who provided the ODBC driver or the documentation (if it exists).

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[IdoMillet]

You can achieve the same end result as a FOJ using a UNION query/view/command.

Let me know if you are not familiar with UNION statement and I'll provide more detail.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[BurnsORegan]

IdoMillet

Please can you enlighten me on the use of UNION?

Thanks for the tremendous help!

Tim

 

[IdoMillet]

If you e-mail me I'll bounce back a little Access database demonstrating this technique.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com