Data Explorer - ODBC data source

[frink333]

I am using Crystal reports v 8.5.
I am using a ODBC data source "sqlserver" to access 3 different databases (WLVDF10, MSVDF10, MSTEST) that all have the same tables in them.

I change the database through the ODBC data source administrator.

When I create a new blank report, I go to database explorer, I select my ODBC data source "sqlserver" and the tables appear like this:

WLVDF10.dbo.DEBTOR

where WLVDF10 is the database name, and DEBTOR is the table name.

As I need the reports just to use the datasource name "sqlserver", and take the database from the ODBC data source, is there anyway I can make Crystal just show me the table names ie DEBTOR, rather than the actual database name ie WLVDF10.dbo.DEBTOR

Hope this is fairly clear.

Thanks.

 

[synapsevampire]

You can remove the server name in the Database->Set Location.

That way when you change ODBC drivers it should just work.

If the structures have any differences you'll still need to do a Database->verify database though.

-k