| The information in the article refers to |
Crystal Reports
Crystal Reports
In Crystal Reports, you can build complex formulas using the Boolean operators AND, OR, and NOT.
When two or more Boolean operators are present in a formula, the order in which they are processed is known as precedence.
What is the Boolean order of precedence in Crystal Reports?
The following describes the Boolean order of precedence in Crystal Reports.
NOT is processed before AND, and OR is processed last. If a query has two or more operators of equal precedence, the leftmost operator is processed first. However, parentheses can be used to override these rules.
The following lists the Boolean order of precedence in Crystal Reports:
1st: ( )
2nd: * / + -
3rd: NOT
4th: AND
5th: OR
For example:
- {db.doc type} = 'book' OR {db.doc type} = 'review' AND {db.author} = 'Smith'
This formula finds all records where the document type is 'book', or where the document type is review and an author is named 'Smith'.
- ({db.doc type} = 'book' OR {db.doc type} = 'review' ) AND {db.author} = 'Smith'
This formula finds all records where the document type is books or reviews, where an author is named 'Smith'.
Have a question for our trainers?
Click here to send your questions!
|
