How to Apply Boolean Formulas in Crystal Reports? . The Complete SAP Crytal Report Developer Course 2023 [Videos].

There are different Boolean operators that can be used in formula in Crystal Reports. They are − AND OR NOT Eqv Imp XOR

All these operators are used to pass multiple conditions in formulas −

AND operator is used when you want both the conditions in the formula to be true. Other Boolean operators and their meaning is as mentioned in the above snapshot.

Using Boolean Operators "AND" −

If {CUSTOMER.CUSTOMER_NAME} [1 to 2] = "AN" and
ToText({CUSTOMER.CUSTOMER ID}) [2] = "4" then
"TRUE"
Else
"FALSE"

Using Boolean Operators "AND" and "OR" −

If ({CUSTOMER.CUSTOMER_NAME} [1 to 2] = "AN" and
ToText({CUSTOMER.CUSTOMER ID}) [1] = "4") or
({CUSTOMER.CUSTOMER_NAME} [1 to 2] = "Ja" and
ToText({CUSTOMER.CUSTOMER ID}) [1] = "2") then
"Five star rating CUSTOMER"
Else
"1 star rating CUSTOMER"