Skip to Content
Author's profile photo Former Member

How to Search All Formulas in Crystal Reports

One very common task report writers have when modifying a Crystal Report is to remove a field from the report (i.e. formula, parameter fields). However, Crystal Reports will not let you remove a field that is still in use in the report. Removing all references to a field can be tricky as they can be used almost anywhere such as in formulas, record selection, and conditional formulas. New search functionality solves this problem since Crystal Reports XI Release 2.  You can access this search feature in two ways. You can right click the field object either in the Field Explorer or on the report canvas and select “Find in Formulas”. The other way to access the formula search is to click on the “binoculars” or press Control-F while you are in the Formula Editor. The new search option defaults to searching through “All Formulas”. There is also a second new search option which will search “All SQL Expressions” as well.

Crystal Reports Find in Formulas

Henry, Crystal Reports Product Manager

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.