Connecting to multiple instances!!!

[Guest_imported]

Hi,
I have a report that I need to connect to multiple instances of Oracle. Need help to know how to do that!!

for example, I have created a report in Crystal to point to Instance 1 of the Oracle database. If I need to run the report against Instance 2 of Oracle database I have go and create an additional copy of the report, but this time with an ODBC connection to the second instance of Oracle.

Or

modify my report to point to the second instance.

Is there a way, where I can make my report to run against both Oracle instances, basically have one report with multiple ODBC connections

Thanks,
Samir