Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Database Expert Link Errors w/ Outer Join Post Reply Post New Topic
Author Message
adammcc81
Newbie
Newbie


Joined: 07 Oct 2010
Location: United States
Online Status: Offline
Posts: 1
Quote adammcc81 Replybullet Topic: Database Expert Link Errors w/ Outer Join
    Posted: 07 Oct 2010 at 6:49am
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"



IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.