Use formulas as conditions for multiple OR conditions.

Example: You want to print an employee list for all active employees that are part of the Salary or Field pay groups. The conditions need to retrieve records where the termination date is blank or the rehire date is greater than the termination date, as well as employees that are part of one of the two pay groups.

Setup the formula for active employees as follows:

Termination Date [PR Employee] = "" OR Rehire Date [PR Employee] >= Termination Date [PR Employee]

Setup the formula for the pay groups as follows:

Pay Group [PR Employee] = "Salary" OR Pay Group [PR Employee] = "Field"

Add the conditions to the report as follows:

1. From the Report Designer Design menu, select Conditions.
2. If you already have conditions entered for this report, click Add.
3. Click Index and select Design Formulas or Public Formulas, depending on where you save the above formulas.
4. Select the Active Employees formula, for the Operator select Equal To, and select the Value check box and click OK.
5. Repeat step 4 for the Pay Group formula.