CR 9 SQL Command and changing the data source 1

[tseaman]

I have written a report in CR9 using the new SQL Command feature. It works great. However, now I need to change the way I connect to the database from a DSN to a DSN-less connection string. Crystal associates the SQL command with the DSN connection so when I change the connection type it does not carry over the SQL command. Consequently, Crystal deletes all the fields on the report coming from the command.

Is there any way to switch connections to the same database or to another database with the same schema without rebuilding the report?

 

[chelseatech]

The first thing that comes to mind is to copy your SQL command to the second DSN, and then use Set location to select the second SQL command.

Saving the SQL command in the repositry might help in the migration. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[hhiebert]

I tried this out....didn't seem to work. Anybody figured out a solution for this...or stumbled across one? hh...