Print Page | Close Window

connecting crystal reports to oracle database

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8015
Printed Date: 01 May 2025 at 2:41pm


Topic: connecting crystal reports to oracle database
Posted By: rampa
Subject: connecting crystal reports to oracle database
Date Posted: 13 Oct 2009 at 7:08pm
Hi All,
 
please anyone of you kindly help me.
 
Actually i am new to the crystal reports.
 
could anyone kindly explain me step by step
 
HOW TO CONNECT CRYSTAL REPORTS TO ORACLE DATABASE.
 
thank you,
 
rampa


Replies:
Posted By: lockwelle
Date Posted: 23 Oct 2009 at 6:48am
for the simplest of reports,
create a ODBC driver to the oracle database
open crystal, select a new report, select the same odbc connection that you just create, verify the credentials done.
 
If you can't create the ODBC connection, there are plenty of resources on the web that will tell you.  I don't use oracle here, but have used it years ago.  How to connect is always the same.
 
As an alternative, if you are calling CR from an application, have you application gather the information and then push it to CR using the setDataSource.
 
HTH

Posted By: hilfy
Date Posted: 28 Oct 2009 at 10:18am
In Crystal do the following:
 
1.  Go to the Database menu and select Database Expert.
2.  Click on the '+' next to "Create New Connection".
3.  Wait for the list to come up and scroll down to click on "Oracle Server".
4.  Under "Service" enter the TNSNames alias for your database.
5.  Enter User ID and Password.
 
Two things to note:
 
1.  If "Oracle Server" is not on your list of possible connections, the driver wasn't installed when Crystal was installed.  You'll need to update your install to include the Oracle driver.
 
2.  The Oracle client software MUST be installed on the computer where Crystal is running.  The driver in Crystal is just a connector between Crystal and the Oracle client - it is NOT the Oracle client itself.
 
Also, the ODBC connection that lockwelle mentions is slower than the native Oracle connection and doesn't give you access into Oracle-specific SQL for things like SQL Expressions.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window