Crystal Reports & SQL Server

We have developed some Crystal Reports in a VB app we are building for a client. Initially the Reports hit our development database. We have now imported real data into another database on the same server. We need to change the connection string on these reports to point to a different Initial Catalog. However, this isn’t something that CR seems to want to do. Does anybody out there have any expertise in CR and could tell me how to change the database it is pointing to?

We tried Set Location, but it only wants to reference a single table, and the query string references more than one table.

We need to figure this out, because 1. I need to start beta testing right away, and 2. when we move it to their production server, it willneed to be changed again.

Thanks for any and all help!!!

Bob