I am using Crystal Reports 2008 w/ all current updates. When I create a report and link two tables I am attempting to create Left Outer Joins between two databases. When I do this I receive an error message. I have tried switching the link direction, and multiple other things, and I cannot get it corrected. This report will however work in Crystal Reports 11. Same file, same Left Outer Join. The file was originally created in CR2008. I have tried on both windows 7 and windows xp sp3 computers. I am using Faircom Ctree Sql driver version Faircom 8.27.124 Build 070608. The correct relationships are in order, and like I said it works correctly in the older version. I have screen shots of the error as well as the sql summary under the database option which can be seen below. The same type of join is used for NMmain and works as intended in both versions. I can supply any other information that I may have left out. I updated to the latest available Faircom ODBC ctree Sql driver.
SELECT "cdcall"."nature", "cdcall"."reptd", "cdcall"."rtaddr", "cdcall"."rtcity", "nmmain"."last", "nmmain"."first", "nmmain"."street", "cdcall"."contact", "cdcall"."caddr", "cdcdesc"."comnt"
FROM {oj ("admin"."cdcall" "cdcall" LEFT OUTER JOIN "admin"."cdcdesc" "cdcdesc" ON "cdcall"."number"="cdcdesc"."callid") LEFT OUTER JOIN "admin"."nmmain" "nmmain" ON "cdcall"."compln"="nmmain"."number"}
WHERE ("cdcall"."reptd">={ts '2010-10-06 06:00:00'} AND "cdcall"."reptd"<{ts '2010-10-08 00:00:00'})
ORDER BY "cdcall"."reptd"