For each prompt you create, you can modify its properties by specifying values in the Properties pane. For example, you can
Some properties you set for a prompt may be overridden under some conditions. For example, some properties set for the filter associated with a prompt may override the corresponding prompt property.
By default, when you create a prompt, Report Studio selects the prompt control interface. You can change the prompt control interface depending on the type of prompt you created. For example, for a value prompt, you can choose a drop-down list, a list box, or a radio button group.
Click the prompt control.
In the Properties pane, set the Select UI property to the interface.
You can specify that a prompt requires user input before the report can run.
Click the prompt control.
In the Properties pane, set the Required property to Yes.
Pause the pointer over the page explorer button 
and click a report page.
From the Data menu, click Filters 
.
Click the filter associated with the prompt.
In the Usage box, click Required.
When you run the report, a star appears next to the prompt indicating that the user must select or type a value.
If you have a cascading prompt and the parent prompt control is required, the child prompt control is disabled. This ensures that users choose at least one value in the parent prompt before they can choose a value in the child prompt. Conversely, if the parent control is optional, then the child control is populated. This gives users the ability to choose values in the child prompt without having to choose a value in the parent prompt.
You can allow users to select more than one value in a prompt. For example, you have a prompt for which users must select a product line. You can modify the prompt so that users can select more than one product line.
If you enable multiple selections, the Auto-Submit property is always set to no.
Click the prompt control.
In the Properties pane, choose whether to allow users to specify more than one value or a range of values:
To allow users to specify more than one value, set the Multi-Select property to Yes.
To allow users to specify a range of values, set the Range property to Yes.
Pause the pointer over the page explorer button and click a report page.
From the Data menu, click Filters .
If you have more than one query defined in the report, you must first click an object linked to a query.
Double-click the filter associated with the prompt.
Change the operator to one of the following:
If you are creating a multi-select prompt, change the operator to in.
For example, [Product_line] in ?Product line? where [Product_Line] is the name of the data item allows users to select multiple product lines.
If you are creating a range prompt, change the operator to in_range.
For example, [Margin] in_range ?Margin? where [Margin] is the name of the data item allows users to specify a margin range.
Each prompt you create in a report provides dynamic validation when the report is run. Validity checks are performed to ensure that the data is correct and that required values are supplied. For example, a star appears next to each required prompt. An arrow appears next to a prompt if you must select or type a value. If you type an incorrect value, a dotted line appears. You can choose whether to show the star and arrow for each prompt.
Click the prompt control.
In the Properties pane, set the Hide Adornments property to Yes to hide the prompt characters or No to show them.
You can specify a default selection for a prompt so that users do not have to select or type a value when they run the report.
Click the prompt control.
To define a range of values, in the Properties pane, set the Range property to Yes.
To specify more than one default selection, in the Properties pane, set the Multi-Select property to Yes.
In the Properties pane, double-click the Default Selections property.
Click the add button 
and
do one of the following:
If you chose to define a single value, type the value as the default selection.
If you chose to define a range of values, type the minimum and maximum values of the range in the Minimum value and Maximum value boxes, respectively.
Repeat step 4 to specify other default selections.
Provide your own values in a prompt to
show something different from what is in the database
improve performance by not accessing the database
provide text for optional prompts, such as Select a value
restrict the number of values available
For example, you have a prompt in which users choose a country. For the database value United States, you want USA to appear in the prompt.
Tip: The Rolling and Moving Averages interactive sample
report 
includes a value prompt. For more information
about The Great Outdoors Company samples, see Sample Reports and Packages.
Click the prompt control.
In the Properties pane, double-click the Static Choices property.
Click the add button .
In the Use box, type the prompt value to add.
In the Display box, type the value that will appear in the prompt.
Repeat steps 3 to 5 to add other prompt values.
To link a prompt value to a condition ,
do the following:
In the Variable box, choose the variable to use or create your own.
For information about creating variables, see Add a Variable.
In the Value box, click one of the possible values for the variable.
Click the static value to link to the variable and click
the edit button 
.
In the Display box, type the value to appear in the prompt.
Repeat this procedure for each additional value.
Add prompt buttons so that users can submit selected items, cancel reports, or navigate between pages.
When you are building prompts and prompt pages ,
you may have to add prompt buttons to submit selections. Some prompt
controls, such as the value prompt, can be set to submit selections
automatically. Other prompt controls, such as the date prompt, require
a prompt button.
Pause the pointer over the page explorer button and click the page to which to add a prompt
button.
In the Insertable Objects pane, on
the Toolbox tab, drag Prompt Button 
to the work area.
Click the prompt button and, in the Properties pane, set the Type property to one of the following actions.
| Goal | Action |
Cancel the report | Cancel |
Go to the previous prompt page | Back |
Go to the next prompt page | Next |
Run the report | Finish |
Reprompt the user | Reprompt |
Create a cascading prompt to use values from one prompt to filter values in another prompt. For example, a report contains the columns Product line and Product type. You create prompts for these columns, and you specify that the Product type prompt is a cascading prompt that uses Product line as the source. When users select a product line, they see only the product types related to the selected product line.
Tip: The Employee Training by Year sample report in
the GO Data Warehouse (analysis) package includes cascading prompts.
For more information about The Great Outdoors Company samples, see Sample Reports and Packages.
To make the cascading source a required prompt, select it and, in the Properties pane, set the Required property to Yes.
Click the prompt control to use as a cascading prompt.
In the Properties pane, double-click the Cascade Source property.
Click the parameter that represents the cascade source.
If the prompt allows users to select multiple values, add a prompt button to the cascade source to provide the cascading prompt with the appropriate values:
In the Insertable Objects pane,
on the Toolbox tab, drag Prompt Button to the report.
Click the prompt button and, in the Properties pane, set the Type property to Reprompt.
To change the text in the prompt button, in the Insertable
Objects pane, on the Toolbox tab,
drag Text Item 
to
the prompt button and type the text.
For more information about how to create cascading prompts, see the Report Studio Quick Tour.
