To many left Joins?

[NeonDuster]

Is there a limit as to how many table joins other then = join you can have in a report? The reason I ask is that my report fails when I try to establish more then one left join in my report. Has anyone encountered this problem before? If so is there a patch or a work-around ?

Thanks in advance
NeonDuster

 

[rhinok]

This phenomenon can sometimes be associated with specific Database drivers. Would you please answer the following questions?

1) To which Database do you connect?
2) Do you connect via an ODBC or Native Driver?
3) Was this driver installed with Seagate Info?

 

[NeonDuster]

1) To which Database do you connect? Oracle 8.0.6
2) Do you connect via an ODBC or Native Driver? Microsoft ODBC for Oracle.
3) Was this driver installed with Seagate Info? I do not belive so.

NeonDuster

 

[rhinok]

Hmm, I connect to both Oracle 7 and 8 Databases using the P2Sora7.dll native driver and don't run into this issue at all.

I also have users that connect via the Seagate supplied ODBC drivers for oracle. Try to connect to your database using the Intersolv driver or the native driver and see if you still have this problem.

You might also try troubleshooting your ODBC connectivity based on published articles at

http://support.crystaldecisions.net.

The following article might be a good start:

http://support.crystaldecisions.com/library/kbase/articles/c2005338.asp

 

[NeonDuster]

Once I setup my driver to use P2Sora7.dll insted of the MS ODBC for Oracle every thing worked out just fine.

Thanks rhinok !