Parameter Field

The Parameter Field module defines filters that restrict records on a report. Values can be provided at run-time or “hard-coded.”

 

Click Common Buttons for a description of the buttons found throughout the system and their uses.

 

 

 

 

Field

Description

Parameter Field

The user selects a field from the dropdown list. This field is required. If the field is not available, return to the Report Fields tab to add the field.

Operand

This field is required. The user selects a field from the dropdown list. The choices are based on the type of field selected in the Parameter Field. This field will be hidden for the special CustomFields field.

 

Check box

  • Is Equal To

 

Date field

  • Is Equal To (this field will allow future dates and is not restricted to project dates)

  • Is Not Equal To (this field will allow future dates and is not restricted to project dates)

  • Is Missing

  • Is Not Missing

  • In Range (this field will allow future dates and is not restricted to project dates)

 

Numeric field

  • Is Equal To

  • Is Not Equal To

  • Is Greater Than

  • Is Greater Than or Equal To

  • Is Less Than

  • Is Less Than or Equal To

 

Select field

  • Is Equal To

  • Is Not Equal To

 

Text field

  • Is Equal To

  • Is Not Equal To

  • Is Like

  • Begins With

  • Ends With

Value

The user selects an item from the drop down list. A value can be selected at this time or the value can be selected by the user at run-time.

 

Check box field

  • Run-time Choice

  • True

  • False

 

Date field

  •  If the Operand select field is either Is Equal To or Is Not Equal To, this field:

    • will be formatted as a standard date field

    • will allow future dates

    • will not be restricted to project dates

  • If the Operand select field is set to In Range, this field:

    • will be set to a Date Range Control

    • will allow future dates

    • will not be restricted to project dates

 

Numeric field

  • This field will be formatted as a standard numeric field

  • The number of decimal places and integer places will be based on the parameter field

 

Select field

  • The available choices will be based on the parameter field

  • If the choices would vary by project, then this field will be read only and set to Run-time Choice

 

Text field

  • This field will be limited to 25 characters.

Field Type

This field will be hidden unless the selected Parameter field is a Boolean data type. The available choices are:

  • EnabledDisabled

  • OnOff

  • TrueFalse

  • YesNo

This field is required if visible. The value of this field will be used to populate the choices in the select field for this parameter at runtime.

Hidden

The user places a check in the box if the field should be used as a filter. If this check box is checked, the parameter field will not be displayed when the report is run. This field will be hidden for the special CustomFields field.

Read Only

The user places a check in the box to prevent the user from modifying the value of the field at run-time. This field will be hidden for the special CustomFields field.

Required

The user places a check in the box to have the user enter a value for this parameter at run-time.