Criteria Menu

These columns and menus allow the user to specifically define criteria for the fields in JReport.  For example, let's say one of our fields is labeled Region.  This field is a listing of all 50 states in the United States.  Your report only wants to see information from New York (NY) and California (CA).  In the criteria menu, you are able to pick NY and CA out by placing their names in the column as seen below.   



Just type in NY and CA.  JReport automatically places the ='xx' (equal sign and quotes) in the column for you.  Below is a listing of the syntax that is available:

• Comparison predicates ( =, >, <, >=, <=, <> )
• BETWEEN predicate  (example: BETWEEN 1 AND 100)
• IN predicate (example: NOT IN (1, 3, 5))
• LIKE predicate (example: LIKE '%apple%'
• NULL predicate (example: IS NOT NULL)