Hi folks,

We're using the german version 6.0 of CR. Our old structure of our
database-system included all tables in only one database. From this
point we developed the reports.

Now the structure has changed, so some tables are in database-1, the
others are in database-2, but the names of the tables did not change. My
question is, how can I switch the datasource-information in the reports,
that I can access onto 2 databases. The menu-item "Database -> Set
Location" doesn't work correctly.

I tried already to change the table about an Alias,  with the result
that all fields from a table which is now in database-2 were being lost,
just as all the WHERE-Clauses from this table.

Thanks a lot ...

Good day Herbert,

There is some good news and some bad news.  

First the bad news.  Using only Crystal 6.0 and database/views as your
data source, you can not access two separate databases (locations) in
the same report.

Now the good news.  That being said, Crystal has sub-report
capabilities.  The sub-reports can extract data from a database
(location) other than the database (location) used in the parent
report.  Unfortunately, you will have to re-code your existing reports
to incorporate sub-reports.

You will ofcourse have to set up ODBC data source info for each database
(location) you wish to use.

We use this approach to extract information from an SQL business systems
database and an Oracle manufacturing database.  It works well but be
aware that the presence of sub-reports increase the response/process
time of Crystal, you will have to wait a bit longer than you are
accustomed to get your report.

Hope this helps.

Cheers,
        ...Chris.