I am using CR2008 with MySQL 5.1.
I have a report that works with one of the tables (T1) in a MySQL database (DB1). I have another MySQL database (DB2) with the same table name and structure, except that the data has been updated.
I want to use the same report, but just ask CR2008 to now use DB2 and T1.
Try as I may (using Set Data Source Location...), but I'm not getting anything to work.
I looked for a previous thread on this, but was unsuccessful.
Thanks for any help.
David