Change the name of the field displayed in the report by updating the alias cell in the corresponding row within the Controls tab of the Selected Controls grid. Alias as many fields as necessary before generating a report.
Records can be filter within a report by providing field specific criteria. Click the Filter tab and enter the desired criteria into the form and press the save button. Multiple filter criteria can be entered for each report with either an "and" or "or" conjunction. The "and" criteria signifies that all filters must be true in order for the record to be displayed. The "or" criteria means that any filters can be true for the record to be displayed. The following Key should be used to determine the proper operator to use when selecting filter criteria:
|
Operator
|
Explanation
|
Example
|
| LIKE |
contains the text |
LIKE 'Shark' |
| = |
equals |
= 25 |
| <> |
not equals |
<> 0 |
| > |
greater than |
> 40 |
| < |
less than |
< 40 |
| >= |
greater than or equals |
>= '1/25/2008' |
| <= |
less than or equals |
<= '5/4/2008' |
 |
Click on Icon to Watch Instructional Video |