Report Studio

Creating a Parameter to Produce a Prompt

Report Studio can automatically generate prompted reports based on parameters you create. When you run the report, Report Studio can generate a prompt page for each parameter not associated to an existing prompt page, depending on whether the prompt run option is selected or not.

You also define parameters when you want to create a drill-through report, and you can use parameters to define master-detail relationships .

To create a Parameter to Produce a Prompt:

From the Data menu, click Filters .
On the Detail Filters tab, click the add button.

The Detail Filter dialog box appears.
In the Available Components box, click the source or data items tab to select the data item you want to use for the prompt:
To filter data based on data items not shown in the report, double-click a data item on the source tab .
To filter data that appears in the report but not necessarily in the model, such as calculations, double-click a data item on the data items tab .

The data item appears in the Expression Definition box.

In the Expression Definition box, type an operator after the data item, or select an operator from the functions tab.

The operator sets some of the default properties of the prompt. For example, if the operator is equals (=), users will be able to select only a single prompt value, and the prompt's Multi-Select property is set to No.

For more information about creating expressions, see Using the Expression Editor.
Type a name after the operator to define the prompt parameter. A question mark must precede and follow the name.
In the Usage box, click one of the following:

To create a required prompt, click Required.
To create an optional prompt, click Optional.
To specify not to use the prompt, click Disabled.