Crystal 10 - Client changed db file server location

[CrystalLion]

My client recently implemented a new database server and transferred their database to it. When we try to run Crystal reports, it appears there is no centralized way of getting all of the reports to acknowledge the new server name. It's acting like I need to Set Datasource Location in every single report to get Crystal to acknowledge the new file server name.

Is there an easier, one time for all reports, solution? My client has hundreds of reports.

I am using a Progress OpenEdge driver with an SQL view of the Progress database.

Thanks

 

[Bennie47250]

I would check out .rpt inspector. While I have never actually used the product in production, it was powerful and seems like it would be capable of doing this.

http://www.softwareforces.com/?pid=ri3ps&ad=tekrips:2

(They are a Tek-Tips sponsor)

 

[CrystalLion]

Thanks Bennie - I will try it out and post back.