For greater control over drill-through access,
you can define parameters in the target report in Report Studio.
Procedure
- Open the target report in Report Studio.
- Ensure that the report is available for drill-through access:
- From the Data menu, select Drill
Behavior.
- In the Basic tab, select Accept
dynamic filters when this report is a drill-through target and
then click OK.
- Create a parameter that will serve as the drill-through
column, or that will be used to filter the report. (Data menu, Filters).
For example, to drill through or filter on Product line,
create a parameter that looks like this:
[Product
line]=?prodline_p?
Tip: Use the operators in or in_range if
you want the target report to accept multiple values, or a range of
values.
- In the Usage box, specify what to
do when a value for the target parameter is not passed as part of
a drill-through:
- To specify that users must click a value in the source report,
click Required.
If a value for the target
parameter is not passed, users are prompted to choose a value.
- To specify that users do not need to click a value in the source
report, click Optional.
Users are not prompted
to choose a value and so the value is unfiltered.
- To specify not to use the parameter, click Disabled.
The
parameter is not used in the report, and therefore not available for
drill-through definitions. For more information about defining report
parameters, see the Report Studio User Guide.
Tip: If the parameter is needed in the report for other reasons,
then you can also specify not to use it in the drill-through definition
(Parameters table, Method, Do
not use parameter).
Results
The drill-through definition controls when prompt pages or
parameters are displayed.
