We are using cr11 with oracle 9i.
I create a report for oracle. The sqlstatement I create also hasa few joins in it. These joins have the old oracle-syntax like :
select * from emp, dept where emp.deptno = dept.deptno(+)
When I execute the report in crystal reports 11 everything is ok. When I get the sqlstatement through IReport::GetSqlQueryString() I get the sqlstatement with the new-oracle-join-syntax:
select ename, dname, emp.deptno, dept.deptno
from SCOTT.EMP LEFT outer join SCOTT.DEPT
on emp.deptno = dept.deptno
The problem with the new oracle-join syntax is that you can't join more columns than 1000, even if you select just 1 column.
FROM X LEFT OUTER JOIN Y ON X.ID = Y.ID
LEFT OUTER JOIN Z ON X.ID = Z.ID
This is why we want the original query.
Why don't I get the original-syntax? Is this strange cr11 behavior?
Is it configurable? Can anyone tell me something about it?