Deleting all unused formulas at once

Friday 16 September 2016 @ 8:03 am

Sometimes when overhauling a report I will have a long list of formulas with many of them no longer needed. You can tell which formulas CR is actually using by the check mark next to each field in the Field Explorer. You can delete these unused formulas individually. If there are groups of them listed together you can select a range of formulas and hit “delete”. But here is a quick way to delete ALL of the unused formulas:

  • Click on the the first formula in the Field Explorer (even if it is in use)
  • Hold your shift key and click on the last formula in the Field Explorer (even if it is in use)
  • Hit the delete key.
  • You will get a warning that you are trying to delete fields that are in use. Click “No”
  • Crystal will delete all of the fields in the list that are not being used, but leave the others alone.

Even if you click “Yes”, Crystal can only delete some of the formulas that are in use. If a formula is sitting on the report layout but is not being used in any other way, Crystal can delete that formula from the list. To delete the other formulas you have to find where they are being used and replace them.

(For examples of my most popular formulas, please visit the FORMULAS page on my website.)

Leave a Reply

Recrystallize Pro