Solved

crystal Reports

Posted on 2004-09-30
9
1,820 Views
Last Modified: 2012-05-05
I am a  business user who writes a lot of queries to extract data from a Oracle database .  But now I want to create better lookinng and more efficient reports . I have just got crystal reports in my machine . Could you pl. tell me step by step about how to connect to an Oracle database from crystal (odbc , tns etc are totally new to me ; have just heard people use it often) So step by step instructions please. I want to connect to the oracle databse and then run a query that I wrote- (SQL) and then get the results in crystal reports and not excel... as I usuallly do...
0
Comment
Question by:Sara_j_11
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12195067
First of all, what version of Crystal Reports do you have and what version of Oracle?
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 100 total points
ID: 12199341
0
 

Author Comment

by:Sara_j_11
ID: 12199526
I know that I am running Crystal reports 9, since I jsut got that installed; but I dont know about Oracle. CAn u pl. tell me how I can find that out from my PC.
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:Sara_j_11
ID: 12199578
ok I just found out that I am running oracle 9i
0
 
LVL 42

Accepted Solution

by:
frodoman earned 400 total points
ID: 12199653
Setting up connection on WinXP:

Start -> Control Panel -> Admin Tools -> Data Sources(ODBC) -> System DSN -> Add -> Oracle ODBC Driver or Microsoft ODBC for Oracle.

The datasource name and description can be anything you want - this is what you'll see in Crystal when you want to connect later.  The service name and user id must be provided by the Oracle DBA.

Now in Crystal:

Create new report -> Create New Connection -> ODBC(RDO).  Pick the datasource you just created and enter the password supplied by your DBA.  You'll need to enter the password every time you connect because the Oracle ODBC drivers won't store the password for you.

Once the connection is made Click the + to the left of the appropriate schema (you'll see all the schemas that exist even if you don't have authority to use them).  Double click on the "Add Command" option and a window will open where you can enter your SQL.

HTH

frodoman
0
 

Author Comment

by:Sara_j_11
ID: 12200297
I just tried doing it.. It gives me the following error:
Not implemented
Cannot connect to this data source. This is the crystal Reports standard edition. Please upgrade to the crystal reports Pro in order to connect to it.
What can be done...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12200463
According to this link Oracle 9i is not supported with the standard edition.  You will need to upgrade to at least the Pro edition.

http://support.businessobjects.com/communityCS/TechnicalPapers/cr9feat_ver.pdf

mlmcc
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12200633
It's as mlmcc said.  The process I gave you works just fine but standard edition is restricted (it won't hit oracle 8i either).  If you upgrade to CR9 Pro then you can use the ODBC
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12205868
Glad i could help

mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now