Report Studio

Defining Independent Drill-through Definitions for Crosstabs

By default, you can create only one drill-through definition for fact cells in a crosstab, regardless of how many facts there are. This topic describes how to define different drill-through definitions for different measures in crosstab fact cells.

For example, a crosstab has Quantity and Revenue as measures. For the Quantity cells, you want to define a drill-through definition to a target report that contains more information about quantities sold. For the Revenue cells, you want to define a drill-through definition to a different target report that shows details about revenue generated.

To define independent Drill-through definitions in crosstabs:

Open the source report.
On the toolbar, click the unlock icon.
In the crosstab, click the white space inside one of the fact cells of the measure for which you want to define a drill-through definition.

Do not click the measure text. You want to select the crosstab intersection and not the text item. In the Properties pane title bar, ensure that Crosstab Intersection appears.
In the Properties pane, set the Define Contents property to Yes. The text item in the crosstab intersection disappears.
Click the Data Items tab.
From the crosstab query, drag the measure that disappeared in step 4 to the empty crosstab intersection.
Right-click the measure in the crosstab intersection and then click Drill-Through Definitions.
Create the drill-through definition.

A drill-through definition is defined for the selected measure. Repeat the steps to define different drill-through definitions for other measures in the crosstab. When users run the report, clicking values from different measures takes them to a different target report.