Adding Database

[jonbarr]

Using CR 8.0 with ODBC database.

I am trying to compare data in our live system with data in our "Test Company" which is a stored mirror of the live system that can be used to test new procedures.
This means I am looking at the same field of the same table in two different databases.
I have used the "Add Database" function and set the alias for each table to read "live" or "test" after the table name. Then selected the field I want to compare from each aliased table and set them side by side in the details section with no grouping.
When I try to view the report I get a message "Physical Database not found"
I have checked in the 'Set Location' window, and everything appears to be pointed to the correct source.
Can anybody tell me what I am doing wrong ??

 

[dgillz]

What type of database and what type of connection are you using?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[jonbarr]

Database is ODBC, programme is Great Plains v 8.0
How do I check to see what type of connection it is ??

 

[synapsevampire]

Database isn't ODBC, that's the connection (stands for Open Database Connectivity).

If you're using ODBC to get to 2 different databases, then you'll need 2 different ODBC setups, or you'll have to change the setup back and forth.

Using Database->Set Location allows you to then tell Crystal which one you currently want.

-k