how to create connection between crystal reports a
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=7740
Printed Date: 27 Apr 2024 at 12:33am
Topic: how to create connection between crystal reports a
Posted By: amitchhabra
Subject: how to create connection between crystal reports a
Date Posted: 20 Sep 2009 at 10:36pm
|
Hi,
I am Amit Chhabra. I am using Crystal reports first time so someone please tell me how to create connection between crystal reports and oracle 10g database?
Thanks,
Amit Chhabra
 |
Replies:
Posted By: Jyothi Yepuri
Date Posted: 20 Sep 2009 at 11:06pm
|
Have you setup ODBC connection to Oracle DB?
Jyothi |
Posted By: amitchhabra
Date Posted: 21 Sep 2009 at 1:24am
|
Nope.
Regards,
Amit Chhabra
|
Posted By: Jyothi Yepuri
Date Posted: 21 Sep 2009 at 4:48pm
|
Set up ODBC connection to Oracle database on the system where the report is going to run and use the ODBC connection in crystal report.
Jyothi |
Posted By: amitchhabra
Date Posted: 22 Sep 2009 at 12:53am
|
ok Jyothi. I will try thats. Thanks, Amit Chhabra |
Posted By: hilfy
Date Posted: 23 Sep 2009 at 10:03am
|
You do NOT need an ODBC connection! Crystal comes with a native Oracle driver that is faster and more reliable than ODBC for Oracle. You have to have installed it when you installed Crystal.
You don't say which version you're on, but you can get to it when creating a report - in the first screen of the Standard Report Creation Wizard, select "Create New Connection". When the list comes up, select "Oracle Server". On the Connection screen the "Service" is the database name from your TNSNames file. Note: the Oracle client software MUST be installed on the workstation/server where the report is being run in order for it to work.
-Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |