> Got a question about report. How do you change the table and database
> from Emerald2 to Emerald? I tried to use Crystal report 4.5 and
> changing them by using -- Database / Set Location -- to change the table
> and database to Emerald but the changed report doesn't work. Can
> anybody offer a pointer to me?
Which one did I miss? If you tell me, I can change it.
What I do is go into Database, SQL Statement, and then
edit the Emerald2 to Emerald or just take the database
name completely out (Changing Emerald2..Table to just
Table). The later is the better choice, because then its
not dependant on a specific DB name, it uses the one you
specified in the ODBC DSN.