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 can also define parameters when you want to create
a drill-through report or define master detail relationships
.
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 tab or
the Data Items tab
to select the data item 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.
To specify whether the prompt is mandatory, in the Usage box, click Required, Optional, or Disabled.