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 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