Change report database

I guys:
i have a problem when I am trying to change the report database.

the report is currently using a oracle sql to fetch data into the report. when i try to move it to another database (test envirment) tables’ schema name is changed so i basicly want to use another query on the new DB, i use the “database|set datasource location” window put new query in.
but CR dont let me to. it shows error: "failed to retrive data from database. "
anyone can help me? thanks
:hb:


abyss :australia: (BOB member since 2009-12-17)