Conditions determine the way in which filters interact with each other and the report as a whole. There are two conditions: And & Or. Conditions are set to And, by default. Click the word And to change it to Or and click it again to change it back.
The condition And means that both expressions must be true in order for the record to be placed in the report. The example below shows criteria stating that records must have “O” as the status AND have a WO Date greater than 05/02/2010.
The Or condition is mostly used within filter groups (see next section) to indicate how fields within the group should be treated. Or says that either expression can be true for a record to be added to the report. For instance, if you wanted to see all work orders for two departments out of the ten in your system, you would set up the group filter with the condition Or. This way if either department is on a record, that record will show on the report.
Filters can be programmed to act as one through grouping. Grouping is accomplished by using the left and right parenthesis in the field properties column and specifying the condition of the filter combination.
The last step in establishing a group is to indicate what condition should be used between the fields in the filter group and between the filter group and the other fields on the report.
NOTE: The condition within the filter group falls within the parenthesis, while the condition which connects the filter group to the report occurs just outside of the right parenthesis which ends the filter group.