Crystal Database Source

[crthorn]

I'm having difficulty pointing our report to either our live database or testing server. We have a mySql database server hosting a variety of db's. Our main application uses the live version of the system but we also have a duplicate version for testing purposes. If I create a report for the live version and use the feature under the "Database Menu" to "set datasource location" it updates the report but still pulls from the live db. I've tested this by creating a quick report and just setting it up to connect to the testing db. It provided the correct results but the report that I just moved to datasource still gave the same results as before the switch.

Any ideas would be appreciated.
Chris