1. Right-click on the section to conditionally suppress and select Section Expert (Crystal XI) or Format Section (Crystal 8.5)
  • Click the X+2 button across from the Suppress (No Drill-Down) checkbox
  • In the Formula Editor window, add the condition for when the section should be suppressed

    Example: if you would like to suppress the section if the field {Student_Name} is blank, add the following formula (checks if the field has a null value or is blank):
    isNull({Student_Name}) or Length({Student_Name}) = 0

    Example: if you would like to suppress the section if {Student_Name} is not blank, add the following formula:
    not(isNull({Student_Name}))

    Example: if you would like to suppress the section based on a specific value, add the following formula:
    {Grade_Level} = 10
  • Click Save and Close, then OK
  • Refresh the report
Note: Conditional suppression formulas do not require the If, Then, Else keywords