Changing Datasource when using Commands

[bsibengal]

Changing the datasource in a Crystal Report is simple when using individual tables, but we have not been able to find an easy way to do this when using Crystal commands for the datasource. Any tips on how to change the datasource when using Commands?

 

[kskid]

I usually copy the command to NotePad and make the change there using edit/replace and then replacing it back in the command with paste


-lw

 

[bsibengal]

The command itself will not change, as the table names are the same. The cut and paste may not be feasible, as the database name is what is changing. We are using a similar stock table structure for each of our clients, but need to point to a different instance or database name. The Commands are being used in place of custom Views, as Views are harder to keep track of.

We have to repoint each table to the new database/table to move the datasource, but weren't clear how to move the command in the same scenario.

 

[kskid]

Hmmmm... just tested my oracle databases and I was able to change source

Database -> Set Datasource Location

From the popup, I create a new connection and specify the new DB and click update

-lw