I used a test SQL Database when building a new Crystal report. Now I want to switch to the live Database. I chose "Set Database Location" and clicked on the live database in the bottom window and clicked "Update". Everywhere I check it shows pointing to the live database except in "Database", "Show SQL". Here it still show "From" the test database and the data I get is test data. How does the report "SQL" get update.
Thanks,
BillyBob