Cannot change datasource in CR9

[mouser4069]

We are using Crystal Reports 9.

I have a report in Crystal Reports 9 which runs in our "Test" environment, which is used for developing reports. However, I need to change this report over to our "production" environment.

The report is a SQL command that has been dropped into the command area in Crystal. When you click on Database and "change datasource location" the report sets and sets and does not change. When this has happened previously on other reports, we have chosen the "verify database" option under the Database menu. We have then been able to change the datasource in several of our other reports. However, this report just sets and won't change the datasource.

Can anyone offer suggestions?

 

[IanWaterman]

Not sure if this works for Commands but I have to do this for tables and views when moving from one schema to another.

In set datasource, click on the + by Command and then open properties.

Double click Overridden Qualified Table Name: an type in Command.

Then close hopefully this will make it portable across schemas.

Ian

 

[mouser4069]

Thank you for the idea, but this didn't work with the Command. I tried...

If you have any other ideas, I'd love to hear them!