Changing the Datasource location of reports with commands 1

[fmrock]

Our System admins are moving our SQL server databases to a new server, so a bunch of our reports need to be updated.

The reports i have problems with are those that have commands, the only way i have found to update them is to rebuild them, which is no fun at all, considering i have 50 to update.

Is there a way to change the datasource location of a command?

 

[hilfy]

See my response here:

http://www.tek-tips.com/viewthread.cfm?qid=1473561&page=1

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[fmrock]

Thanks, Thats the one thing i didnt try.

I rebuilt many of them today.. I will use ths tomarrow for sure.

Thanks a million

 

[fmrock]

Worked Perfect today!