Conditional Suppress Objects in Crystal Reports

Depending on the object type, you can suppress (hide) objects, based on some logic.

To suppress most types of objects, such as text boxes and database fields, follow the below steps:

1.  Right-click on the object and select Format Text.

2.  Select the Common tab.

3.  To the right of the Suppress checkbox, click the formula button.

4.  In the formula workshop, enter a formula which results in either true or false.  Note that it is not necessary to include a full if-then statement for this.  If it is a simple formula, you can rely on Crystal Reports computing the result of a simple statement being true or false.

For example:

{EV870_ACCT_MASTER.EV870_COUNTRY} <> "AUS"

Entering a formula always overrides the checkbox setting.  The formula button will display in red as an indicator that the checkbox setting will be overridden.