Updating numerous fields on a report at once 1

[keain]

We have an ERP vendor who on their last update changed a lot of their table names, and shifted some fields around. Needless to say they messed up quite a few of our Crystal Reports (all in Crystal 9).

Is there an easy way to update the report so that all instances of a field on a report can be updated at once instead of hunting for the fields, for example:

job_quote.amount_billed will become invoice_detail.amount_billed

We have about 65 reports that need to fixed now and I wasn't involved in the initial development of the reports, so I don't know for sure where everything in each report is.

 

[Madawc]

You might try Database > Set Datasource Location, or whatever the equivalent is in Crystal 9. 'Change' to the same location, or rather the data as it is now. If you're lucky it will bring up a list of differences and let you equate.

Beyond that, running the report will get all of the differences brought up one at a time.

If different reports have similar fields, you could open Crystal twice and use cut-and-paste to create a 'pool' of fields that need changing.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[jbecker614]

You could take a look at .rpt Inspector from Software Forces.

http://www.softwareforces.com/Product/ri/pro/3/rptinspector.htm