Switching Oracle SID in same report.

[jawilson]

I have created a report against one of four Oracle SID's. I am wondering how to run this report against a different SID.

I have tried logging in to the desired Oracle SID, then opening the report and running it. When I do this it prompts me to log in to the SID in which the report was created orginally. Is there a way to use this report for another SID?

Thanks,
jw [sig][/sig]

 

[kenhamady]

Try this:

Log into both simultaneously.
Then open the report and use:
Database, Set Location

Select one table and &quot;locate&quot; it in the new data source. It will ask if you want to relocate the other tables, and if you say yes it should do all of them. If it doesn't for some reason you may have to do one at a time. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]