icon next to the desired option.
More Query Prompt Options Dialog |
The More Query Prompts dialog allows you to specify data transforms for the database query criteria entered by the user. These transforms can enforce data validation to ensure users are entering appropriate values for the query prompt. The dialog is accessible by clicking the More Options button on the Query Prompts dialog.
To configure a transform, select the icon next to the desired option.
Character Filter: Forces data to conform to specified rules.
Truncation: Removes unwanted characters and spaces from data.
Number of Characters: Specifies the minimum and maximum number of characters that can be entered.
VB Script: Allows you to write Visual Basic Scripts to perform custom data processing or validation.
Prefix and Suffix: Specifies the text that may be appended to the beginning or end of the user-entered value.
Related Topics