Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crystal with Oracle DB Post Reply Post New Topic
Author Message
dv-1028
Newbie
Newbie


Joined: 12 Apr 2010
Location: Malaysia
Online Status: Offline
Posts: 4
Quote dv-1028 Replybullet Topic: Crystal with Oracle DB
     Posted: 12 Apr 2010 at 4:17am
Hi all,
can I know why I can't connect to the table (using OLE-DB with the oracle) with the following select statement below:

select t1.orno as PO_No,
           t1.item as Item_Code,
           t2.dsca as Desc,
           t1.qoor as Ordered_Qty,
           t1.pric as Unit_Price,
           t1.oamt as Total_Amt_Purchased,
           t3.ardt as Receipt_Date,
           t1.dino as D/O_No
    from baan.ttdpur401721 as t1,
         baan.ttcibd001721 as t2,
         baan.twhinh312721 as t3
    where  t1.orno = t3.orno and t1.item = t2.item


Thank you in advance for the help provided.


IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 12 Apr 2010 at 6:50am
What error are you getting?  Does the user ID your report uses have access to the tables?  Why are you using OLE-DB instead of the native Oracle connection that's available in Crystal?
 
-Dell
IP IP Logged
dv-1028
Newbie
Newbie


Joined: 12 Apr 2010
Location: Malaysia
Online Status: Offline
Posts: 4
Quote dv-1028 Replybullet Posted: 12 Apr 2010 at 6:48pm
The error message - Fail to retrieve data from database. 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 13 Apr 2010 at 3:20am

Is there an ORA error with a number or just the message above?

-Dell

IP IP Logged
dv-1028
Newbie
Newbie


Joined: 12 Apr 2010
Location: Malaysia
Online Status: Offline
Posts: 4
Quote dv-1028 Replybullet Posted: 14 Apr 2010 at 6:50am
"Fail to retrieve data from database"
Details: ORA-00904
[Database Vendor Code: 904]
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Apr 2010 at 7:03am
If you do a Google search on this error code, it means "Invalid identifier" or "Invalid Column Name".  If your were actually unable to connect to the database, you would get a different error.
 
Are you using a command in your report?  If so, I would try to run the SQL in a tool outside of Crystal - I generally use Toad, but there are tools that come with Oracle as well - and make sure it runs correctly there.  If you're not using a command, go to the Database menu and click on Show SQL Query then copy the query from there and try to run it outside of Crystal to diagnose the problem.
 
-Dell
IP IP Logged
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