Search and Replace is a powerful tool that will search your Crystal Reports for a given text and replace it with different text. It can also create a log using a pattern.

Search and Replace is helpful when having to convert your reports to a new backend. Often you may find that selection syntax needs to be adapted to the new backend.

Use the pattern search to first locate possible problems then use the replace option to change the values.

Pattern searching supports the following datatypes: boolean, number, currency, date, datetime, time, and string. Pattern searching will check each data field, parameter, or formula field when it comes across that field being used in a selection formula or in a formula field. It will determine whether or not that field is the datatype used in the pattern and report back to you if it is.