Range Checking Dialog |
Use the Range Checking dialog to specify a range of valid dates or values that can be entered in the selected data source. Additionally, you can configure how the application behaves if the data source value is outside of the defined range.
You can use the Range Checking transform for the following data types: Date, Number, Currency, Percentage, or Fraction.
You can access this dialog by using one of the following methods:
For template objects, click next to the transform on the Transforms tab of the Data Sources property page.
For data entry controls, click next to Range Checking on the Data Entry property page.
Depending on the data type that is selected, the following options are available.
Start of Range
No limitation: Specifies that any date can be used as the start of the range for the selected data source.
Today's date is first valid date: Specifies that the current date is the first valid date in the range. This option retrieves the current system time, so it is reset when the current day changes.
First valid date is relative to today's date: Specifies that the first valid date is based on an offset of the current date. This option works together with the Offset option.
Specify first valid date: Sets the first valid date based on the Date field or the calendar selector.
Get first valid date from database field: Retrieves the first valid date from the connected database. This means that the date range can vary based on the database record that is being printed or viewed.
Get first valid date from named data source: Retrieves the first valid date from a named data source in your document.
Start of Range Options
Warn when date is before first valid date:
Offset: Specifies the number of days, weeks, months, or years to add to or subtract from the date that is specified in the Start of Range section of the dialog. The resulting date is the first valid 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 then select Days, Weeks, Months, or Years from the adjacent list. The first valid date is then calculated by using today’s date and adding or subtracting the offset value that you entered.
End of Range
No limitation: Specifies that any date can be used as the end of the range for the selected data source.
Today's date is last valid date: Specifies that the current date is the last valid date in the range. This option retrieves the current system time, so it is reset when the current day changes.
Last valid date is relative to today's date: Specifies that the last valid date is based on an offset of the current date. This option works together with the Offset option.
Specify last valid date: Sets the last valid date based on the Date field or the calendar selector .
Get last valid date from database field: Retrieves the last valid date from the connected database. This means that the date range can vary based on the database record that is being printed or viewed.
Get last valid date from named data source: Retrieves the last valid date from a named data source in your document.
End of Range Options
Warn when date is after last valid date:
Offset: Specifies the number of days, weeks, months, or years to add to or subtract from the date that is specified in the End of Range section of the dialog. The resulting date is the last valid 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 then select Days, Weeks, Months, or Years from the adjacent list. The last valid date is then calculated by using today’s date and adding or subtracting the offset value that you entered.
Manage Named Data Sources: Opens the Named Data Sources dialog so that you can manage your named data sources.
Minimum Value
No Limitation: Specifies that any value can be used as the minimum value for the selected data source.
Specify minimum value: Specifies the lowest valid value for the Minimum Value field.
Get minimum value from database field: Retrieves the lowest valid value from the connected database. This means that the numeric range can vary based on the database record that is being printed or viewed.
Get minimum value from named data source: Retrieves the lowest valid value from a named data source in your document.
Minimum Value Options
Warn when value is less than minimum value:
Offset: Specifies a number to add or subtract from the value that is 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 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: Specifies that any value can be used as the maximum value for the selected data source.
Specify maximum value: Specifies the highest valid value for the Maximum Value field.
Get maximum value from database field: Retrieves the highest valid value from the connected database. This means that the numeric range can vary based on the database record that is being printed or viewed.
Get maximum value from named data source: Retrieves the highest valid value from a named data source in your document.
Maximum Value Options
Warn when value is greater than maximum value:
Offset: Specifies a number to add or subtract from the value that is 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 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.
Manage Named Data Sources: Opens the Named Data Sources dialog so that you can manage your named data sources.