Display parameter on form as: | Select a parameter display type: |
Prompt | Prompt for the parameter |
Data Type | Data type (text, numeric, or date; default is text) |
Presentation | Presentation format: drop-down list, option buttons, or list box (Pre-determined and SQL query only) |
Default value | Enter a default value or allow users to change the value (predetermined and text entry) If Value optional is unavailable, the system requires a default value or requires that End-user can change value is selected. When $FIXED_USERNAME is selected, Value optional and End-user can change value are disabled. |
Value optional | Allows the parameter to have no default value and enabling users to execute jobs with no value for the parameter |
End-user can change value | Allows users to enter default values during runtime If no default is specified and this option is selected, users must specify default values. When this option is selected, the allow multiple values field is selectable (predetermined and SQL query only). |
Allow multiple values | Allows multiple values (list box presentation only) If multiple values selected are used to create dynamic selection criteria within the Production Reporting program, the program must be designed to construct a WHERE clause. |
Validation Type | Validation type (text only). |
Validation Mask | Standard or custom validation mask (text only) |
List Values | Values moved to the list with the right-facing arrows (predetermined only) Delete values by selecting them in the list and selecting the left-facing arrows. |
SELECT/FROM/WHERE | SQL commands for retrieving the parameter list (SQL query only). |