Hi,

Could some one from this forum please have a look on my problem?
I will greatly appreciate if I get the solution for my problem.

Problem:

I am facing a problem when executing the crystal report on different computers.
I am using an Oracle database 8.1.7.0 with the crystal report version 9 (standard).
I am using different computers, all of these computers have windows 2000 server installed.

With regards to database connection, I am using OLE DB (ADO) as a data source, and then I select the provider (Oracle Provider for OLE DB), then on OLE DB (ADO) tab, I provide the connection information like (Data source > ORA, User Id > SYSTEM, Password> Manager), then I click the next button here I found “Advance Information”, I didn’t change any information here and then click finish in order to establish the database connection.
Then I enter my query via Add command in order to get the particular information.

My Query For Example:
Select empno ,ename, sal,job from scott.emp;

I am getting the correct information when I run the crystal report on the computer where I created this report.

In order to run this report on different computers and get the correct information, I was trying to make some changes in the report.

To do that, I go to Database tab, then go to set data source location. Here we can set the current location which is the location of the computer that I created the report initially that is “ORA”.
 This can then be replaced with the location I have on different computers.

But when I want to replace a location which was “ORA” with new one for example “ORCL” on different computer, I receive a following Error:
“Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables.”

I think I should not save any database connection information with the report as this will be different on every system.

How should we do that so the report which I created with the single sql script can run on different computers and give the correct information.

I will be thankful to you if someone gives me the solution.




Yours sincerely,

Wolfgang Benvort.