You can have a report that contains a drill-through definition that can be filtered by multiple values in a single query item. For example, while analyzing an OLAP source, you may want to focus on Canada and the United Kingdom. When you drill through, the target report is filtered by both countries. After you run the report in Report Viewer, you are prompted to choose values when you navigate from the report to the drill-through target. The values you specify are used to filter the results in the target.
For more information about drilling through to a target, see Drill Through to Another Target.
Drilling through using multiple values is available regardless of whether the drill-through definition is authored in the Report Studio source report or in Reporting Center, Drill-through Definitions. In previous releases, this functionality was available only when the definition was authored in Reporting Center.
Run the report in Reporting Center and view it in Report Viewer.
Note: Alternatively, you can open a Query Studio or PowerPlay Studio report in their respective studios.
Ctrl+click to select more than one value in a column.
If hyperlinks appear in the column in which you are attempting to select cells, click in the empty area around the hyperlinks.
If there are no visible hyperlinks but you know that a drill-through target exists, select the cells you want to use as the filter, regardless of whether they are in the same column. Note that when you select multiple values from different columns, the resulting filter in the target report performs an and rather than an or operation with the values passed, for example, Canada and Camping Equipment; United Kingdom and Fax.
Right-click in one of the selected cells from which you want to navigate, and from the menu that appears, do one of the following:
Under Go To, click the drill-through target name, if one exists.
Under Go To, click Related Links. On the Go To page, click the target report you want to run.
The target report runs and if it can be filtered by the selection made in the source report, the target is filtered by those values.
