Details on New/Edit Prompt

This dialog lets you define that the end users opening this data connection should be prompted for input of one or more values. The data to analyze is then limited based on these inputs.

Option	Description
Select column or parameter	Select the column or parameter for which you want to add a prompt.
Prompt type	The type of prompt to show for the selected column or parameter. You can select from the following prompt types: Manual input lets you enter any value to include (for string columns or numeric columns). This prompt type should only be used if all end users of the data connection know which values are valid for the column or parameter, or if applicable values are shown in the description. For boolean values you get to pick a value using radio buttons (True/False) and for date columns you can choose a date from a calendar. Range lets you specify a range of values. This prompt type is suitable for numerical or Date/DateTime/Time columns when a sustained range of numbers or time periods are to be retrieved. Dates can be selected from a calendar. Multiple selection presents a list of available values from which you can select multiple values. This type of prompt can be used even if the end users of the data connection have no previous knowledge of the data. Single selection presents a list of available values from which you can select a single value only. This type of prompt can be used even if the end users of the data connection have no previous knowledge of the data. See also Details on Open connection.
Min selections	[Only applicable for prompt type: Multiple selection.] Used to specify that the end user of the connection must select at least the minimum number of values to be able to continue.
Max selections	[Only applicable for prompt type: Multiple selection.] Used to specify that the end user of the connection cannot select more than the maximum number of selections in the prompt dialog.
Description	The description is shown in the Open connection dialog when the end user of the connection is prompted for input. By typing a good description when setting up the connection you can help ensuring that the end users know what they should enter or select when prompted for input.