Print Page | Close Window

Using Database Linked fields

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=10553
Printed Date: 29 Apr 2024 at 4:09pm


Topic: Using Database Linked fields
Posted By: AdrianH
Subject: Using Database Linked fields
Date Posted: 16 Jul 2010 at 2:42am

Hello,

I am having a few problems with a Crystal Report at the moment.  The report gets data from two databases (ODBC (RDO)) - Data and LoginDB.  Since the report is run within an application which doesn't have access to the LOGINDB source - we have had to create LOGINDB database link in Prod. 
 
We have created the database link - however when we go into the Database Expert - we cannot see the logindb tables in the Prod environment.
 
The database link seems to be working (I have selected data from the logindb via SQLPLUS (i.e. select * from mailto:users@logindb - users@logindb ).  However, I cannot see the tables in the Database Expert.  How would I introduce these tables into the report?
 
Many Thanks in advance
 
Adrian


Replies:
Posted By: hilfy
Date Posted: 16 Jul 2010 at 8:59am

Crystal doesn't see tables through Oracle Database Links.  However, you can use them in a Command where you would write the SQL to gather your data instead of having Crystal write it for you based on the tables you select.

-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