For greater control over drill-through access, you can define parameters in the target report. For more information about defining parameters, see the Report Studio Professional Authoring User Guide or the Query Studio User Guide.
Steps in Report Studio
Open the target report in Report Studio Professional authoring mode.
2Ensure 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?Note: Use the operators
inorin_rangeif 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 Professional Authoring User Guide.
Note: 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).
The drill-through definition controls when prompt pages or parameters are displayed.
Steps in Query Studio
Open the target report in Query Studio.
2Confirm that the report is available for drill-through access:
From the menu, select Run Report, Advanced Options.
Select Enable drill through from a package in the report output and then click OK.
Create a filter that will serve as the drill-through parameter, or that will be used to filter the report.
Select the column that you want to filter on, and click the filter button.
Change the settings as needed, and click OK.
