Point SQL Command to Different Server 1

[neilkonitzer]

I have about 60 reports that use SQL Commands that point to a test server. How can I modify the reports so that I can start pulling data from the production server?

The set database location UPDATE feature does not appear to be applicable to commands. The only option I know of is to create a copy of the command with the production server and then drag and drop the new fields over, replacing the existing ones. There has got to be an easier way!!!

Thanks in advance.

Neil

 

[hneal98]

go to Database|Set Location, from the main menu.

 

[neilkonitzer]

Thanks, but as I stated in my post, it appears that it does not work for Command objects.

Neil Konitzer
Freisoft Consulting Services, Inc.

http://www.freisoft.com

 

[hneal98]

Ok. At the risk of sounding ignorant, give me an example of one the command objects.

 

[vidru]

Here's a workaround for CR 9 that works if the Command was added to the Repository:

http://support.businessobjects.com/library/kbase/articles/c2012566.asp

I don't know of any other way...

-dave