Range Checking Dialog |
The Range Checking dialog enables you to specify a range of allowable dates or values that can be entered in the selected data source. Additionally, you can define the application's behavior if the data source value is outside of the defined range. You can use the Range Checking transform if one of the following data types are selected: Date, Number, Currency, Percentage, or Fraction.
You can access this dialog in one of the following ways:
Click next to the transform on the Transforms tab of the Data Sources property page (for template objects).
Click next to Range Checking on the Data Entry property page (for data entry controls).
Depending on the data type selected, the following options are available:
Start of Range
No limitation: When selected, allows any date as the start of range for the selected data source.
Today's date is first valid date: When selected, makes the current date the first valid date in the range. This option retrieves the current system time, so it will reset when the current day changes.
First valid date is relative to today's date: When selected, bases the earliest allowable date as an offset of the current date. This option works in conjunction with the Offset option, detailed below.
Specify first valid date: When selected, sets the earliest allowable date based on the Date field or the calendar selector.
Get first valid date from database field: When selected, pulls the earliest allowable date from the connected database. This allows the date range to vary based on the database record that is being printed or viewed.
Get first valid date from named data source: When selected, pulls the earliest allowable date from a named data source in your document.
Start of Range Options
Warn when date is before first valid date:
Offset: Defines the number of days, weeks, months, or years to add to or subtract from the date specified in the Start of Range section of the dialog. This will be the earliest allowable date for your data.
When First valid date is relative to today's date is selected, you can enter an offset value (an integer) into the Offset field, and select the unit from the adjacent dropdown list. The first valid date is then calculated by taking today’s current date and adding or subtracting the offset value you entered.
End of Range
No limitation: When selected, allows any date as the end of range for the selected data source.
Today's date is last valid date: When selected, makes the current date the last valid date in the range. This option retrieves the current system time, so it will reset when the current day changes.
Last valid date is relative to today's date: When selected, bases the last allowable date as an offset of the current date. This option works in conjunction with the Offset option, detailed below.
Specify last valid date: When selected, sets the last allowable date based on the Date field or the calendar selector.
Get last valid date from database field: When selected, pulls the last allowable date from the connected database. This allows the date range to vary based on the database record that is being printed or viewed.
Get last valid date from named data source: When selected, pulls the last allowable date from a named data source in your document.
End of Range Options
Warn when date is after last valid date:
Offset: Defines the number of days, weeks, months, or years to add to or subtract from the date specified in the Start of Range section of the dialog. This will be the earliest allowable date for your data.
When Last valid date is relative to today's date is selected, you can enter an offset value (an integer) into the Offset field, and select Day, Week, Month, or Year from the adjacent dropdown list. The last valid date is then calculated by taking today’s current date and adding or subtracting the offset value you entered.
To manage your named data sources, click the Manage Named Data Sources button at the bottom-left of the Range Checking dialog.
Minimum Value
No Limitation: When selected, allows any value as the minimum value for the selected data source.
Specify minimum value: When selected, sets the lowest allowable value as the value defined in the Minimum Value field.
Get minimum value from database field: When selected, pulls the lowest allowable value from the connected database. This allows the numeric range to vary based on the database record that is being printed or viewed.
Get minimum value from named data source: When selected, pulls the lowest allowable value from a named data source in your document.
Minimum Value Options
Warn when value is less than minimum value:
Offset: Defines a number to add or subtract from the value specified in the Minimum Value section of the dialog.
When Get minimum value from database field or Get minimum value from named data source is selected, you can enter an offset value (an integer) into the Offset field. The minimum value is then calculated by adding or subtracting the offset value from the value of the database field or named data source.
Maximum Value
No Limitation: When selected, allows any value as the maximum value for the selected data source.
Specify maximum value: When selected, sets the highest allowable value as the value defined in the Maximum Value field.
Get maximum value from database field: When selected, pulls the highest allowable value from the connected database. This allows the numeric range to vary based on the database record that is being printed or viewed.
Get maximum value from named data source: When selected, pulls the highest allowable value from a named data source in your document.
Maximum Value Options
Warn when value is greater than maximum value:
Offset: Defines a number to add or subtract from the value specified in the Maximum Value section of the dialog.
When Get maximum value from database field or Get maximum value from named data source is selected, you can enter an offset value (integer) into the Offset field. The maximum value is then calculated by adding or subtracting the offset value from the value of the database field or named data source.
To manage your named data sources, click the Manage Named Data Sources button at the bottom-left of the Range Checking dialog.