How to find fields in a report

[Former Member]

Hi,

A client has customized reports that they need to manually update as there were changes to the database tables. A field that was under table A is now under table B.

When using the Verify Database function, the new table (B) that has been added to the report doesn't appear so you can't map to the new location of the field.

We tried doing a search in the Report Definition document but the results of this export is not 100%; either you don't find the field or not all the locations of it.

Is there a way to find out all the places a field is used or a(nother) field mapping feature that would include the new tables?

Thank you,

Heather

[Former Member · Accepted solution]

You don't mention the version of Crystal Reports XI-R2 or CR2008 (R3) simply open the Field Explorer, find the field with a checkmark to its left (meaning it's used) and right-click on it.

Choose Find in Formulas

If you can't find it in the report definition you should be able to find it this way....

You also may have to do it more than once if it's utilized in more than one formula.