Crystal Reports for Eclipse Designer Guide

And operator

Usage
x And y 
Value of x
Value of y
x And y
True
True
True
True
False
False
False
True
False
False
False
False
Examples
The following example is applicable to Crystal syntax:
If {file.CREDIT LIMIT} = 5000 and {file.SALESMAN} = "SP" Then
     {file.AMOUNT}
Else
     0 
If the credit limit is 5000 and the salesman is SP (both conditions true), then returns the value in the {file.AMOUNT} field, otherwise return zero.
A > B and B > C
Returns TRUE, where A = 10, B = 6, and C = 3 (both conditions are true).
Returns FALSE, where A=10, B=6, and C=7 (only one of the two conditions are true).
(A>B) and (A * C - D > E) and (E / D <= B)
Returns TRUE, where A = 7, B = 5, C = 3, D = 2, E = 10 (all three of the conditions are true).



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