Skip to content
logo Knowledgebase

Unable to save a Suppression Formula in Crystal Reports 2020

Created on  | Last modified on 

Summary

Crystal Reports 2020 can prevent saving suppression formulas through standard formatting dialogs. As a workaround, using the Formula Workshop method allows edits and creation of suppression formulas successfully.

Cause

This is a known SAP Crystal Reports issue for version 2020 released with Sage 100 2023.0.

Resolution

Edit an existing suppression formula

Use Formula Workshop to modify suppression formulas.

  1. Select Report, Formula Workshop.
  2. Expand Formatting Formulas.
  3. Expand the section that contains the field.
  4. Expand the field that contains the suppression formula.
  5. Select Suppress.
  6. Edit the formula as needed.
  7. Click Save and close.

Create a new suppression formula

Use Formula Workshop to create suppression formulas.

  1. Select Report, Formula Workshop.
  2. Expand Formatting Formulas.
  3. Expand the section that contains the field.
  4. Right‑click the field, and select New Formatting Formula.
  5. In New Formatting Formula, select Suppress from the dropdown list.
  6. Click Use Editor.
  7. Enter the suppression formula.
  8. Click Save and close.

Using the Formula Workshop avoids the issue and saves suppression formulas correctly.

Need more help?

Chat now

 

 

Steps to duplicate

  1. In Crystal Reports 2020, open a report.
  2. Insert a Text Object on the report.
  3. Right-click on the Text Object, and select "Format".
  4. In the Format Editor window, under the tab "Common" click the "X-2" button of the option "Suppress".
  5. Enter a conditional suppression formula, and click "Save and Close".
  6. In the Format Editor, the formula icon next to Suppress turns red.
  7. Close the Format Editor window.
  8. The Conditional Suppression formula disappeared.