Selection Criteria - Rental Reports
The Selection Criteria screen allows you to run selected rental reports.
The search field on the Selection Criteria screen is:
| Field | Description |
|---|---|
| Select Report | Select a report type (Utilization) from the drop down list. |
The fields on the Set section on the Selection Criteria screen are:
| Set | |
|---|---|
| Field | Description |
| Field | Select the field represented by the selection data. Depending on the operator code, the system will include or leave out records based on the field data. |
| Operator | The operator represents the selection operator code (e.g. equal to). |
| Value | A value that corresponds to the field selection. |
The available Operator options are:
| Operator | Description |
|---|---|
| Equal to |
Selects customers with Field values that are equal to the value entered in the Value field. For example, if in customer group file maintenance Salesperson (CUSMN) = 12 then customers with a salesperson ID = 12 will be selected. |
| Not Equal to |
Selects customers with Field values not equal to the value entered in the Value field. For example, if in customer group file maintenance Province/State (CUPRV) = 06 then customers with a province/state = 06 will NOT be selected. |
| Greater Than |
Selects customers with Field values greater than the value entered in the Value field. For example, if in customer group file maintenance Size (CUSIZ) = 100 then customers with a size > 100 will be selected. |
| Less Than |
Selects customers with Field values less than the value entered in the Value field For example, if in customer group file maintenance Size (CUSIZ) = 75 then customers with a size < 75 will be selected. |
| Contains |
Selects customers with a Field value that contains the Value field in the Field. For example, if in customer group file maintenance Business Class contains A then customers whose business class contains the letter A will be selected. |
| Does Not Contain |
Selects customers with a Field value that does not contain the Value field in the Field. For example, if in customer group file maintenance Business Class does not contain X then customers whose business class does not contain the letter X will be selected. |
| Range |
Selects data with values within the range entered in the From and To fields. For example, if in customer group file maintenance, Customer Number (CUCUS) range from 00110 to 00120, indicates that customers with customer numbers between the range of 00110 to 00120 will be selected. The range must be specified from lowest to highest. Dates must be entered in the format YYYYMMDD. |
The Query Statement section on the Selection Criteria - Rental Reports screen shows you the criteria you have selected for the specific report.
Click the Advance View link to switch to an advanced mode in order to add more then one set to the Select Criteria section.
Select the Click here to load a saved query link to load a saved query onto the selected report.
Use these buttons to complete your work on the Selection Criteria screen:
| Button | Function |
|---|---|
| Display Query | Display the query in SQL. |
| Clear | Clears only user created queries from the Select Query section, default queries cannot be cleared. |
| Save Query | Saves any queries within the Select Query section. |
| Run Report | Runs the selected report. |
Revision: 2025.07