two different reports with two different data source

[crsdev]

Hello friends,
When i open two different report of different schemas, and try to refresh them, one of them (the first one i try to refresh) asks for password and refreshed fine; but the second one gives errors like "Failed to retrieve data from the database Details: ORA-00942: table or view does not exist" etc..
is there a way to avoid this.
Thanks in advance

 

[synapsevampire]

Use the Database->Set Location and repoint the report to it's data location.

-k