problem with db table qualifier in CR9

[dzavad]

Hi, I have report in CR9 that have invalid db table in it.This report came from another application, but we are trying to use it as the tamplate. Table names are the same but db qualifier is not. EX: db1.Table_Name1 vs. db2.Table_Name1.
When I Verify the database in the CR9 I get error that db1.Table_Name1 cant be found...that is obvious. Because it has wrong qualifier (db1). How can I change the qualifier without wiping all the fields and formulas that contain Table_Name1 fields. db2.Table_Name1 table has the same fields. It will be a time consumming to change all the fields. Do I have an alternetive just by changing qualifier?

 

[vidru]

Have you tried using Database > Set Datasource Location to browse to the new location to update the report? If the tables are laid out in the same manner, that should take care of it.

-dave

 

[dzavad]

THANKS THAT SOLVED THE PROBLEM.