Skip to Content
0
Former Member
Mar 01, 2009 at 08:30 PM

Use same report with different MySQL database

20 Views

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