Skip to Content
Former Member
Jun 26, 2008 at 04:40 PM

Is it possible to edit SQL in Crystal Reports XI?



Iu2019m VERY new to Crystal Reports and I have a few questions, any assistance would be greatly appreciated.

I am converting reports to Crystal Reports XI from C.R. 7.5 and running into some trouble

When I open a report in C.R.-XI- I get the following error: ORA-25156: old style outer join () cannot be used with ANSI joins. I solved most of the join problems by setting all of the join types to equal in C.R. 7.5, then changing them to left outer joins in C.R. XI, but one or two usually remain. So, Is there a way to edit the SQL statement in Crystal Reports XI? When I paste the SLQ (as is) into SQL navigator it gives me the error, but if I change the old outer join (), it works. That is why I was wondering if it is possible to edit the SQL in Crystal XL.