Crystal Reports for Eclipse Designer Guide

Not operator

Usage
not (x) 
Reverses the True or False value of x.
Value of x
Not x
True
False
False
True
  • Not (Not(False)) = False
  • Not (Not(True)) = True
Examples
not (A>B and B>C)
If A=5, B = 4, C = 3, the expression (A>B and B>C) is TRUE. Both conditions tied together by the Boolean operator And are TRUE; thus, the entire statement has a value of TRUE. The Not operator changes the value of the expression to FALSE.
not (A>B and B>C)
If A=3, B = 4, C = 3, the expression (A>B and B>C) is FALSE. One of the two conditions tied together by the Boolean operator And is FALSE; thus, the entire statement has a value of FALSE. The Not operator changes the value of the expression to TRUE.
not ({file.ONHAND} - {file.ORDER} > 0)
Returns TRUE if {file.ONHAND} = 10 and {file.ORDER} = 11.
not ({file.ONHAND} - {file.ORDER} > 0)
Returns FALSE if {file.ONHAND} = 10 and {file.ORDER} = 9.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/