We have a crosstab report that shows sales quantity by month and order method. We need to create drill-through links from months and sales values.
Create two target reports for the drill-throughs. One takes only Month as parameter. The other takes Month and Order Method (Henceforth referred to as Drill-1 and Drill-2 reports respectively).
Create a simple crosstab report to be used as main report. Pull Time dimension | Month on rows, Order method | Order method on columns, and Sales fact | Quantity as measure.
-
Select the Month item placed on crosstab rows. Click on the drill-through definition button
from the toolbar.
- This opens the drill-through definitions dialog. Create a new definition. Select Drill-1 as Target Report. Map the month parameter with the month data item.
-
Now click on the unlock button
from toolbar to unlock the items.
- Select the text item from crosstab intersection. Hit the drill-through button again.
- Create a drill link to Drill-2.
- Run the report and test both the drill links.
You will notice that when we created the drill-through from row titles (month), we didn't have to unlock the items. Whereas, for the intersection, we had to unlock them.
Now try one thing. Lock the report objects again and select the crosstab intersection. Try to create drill-through now. You will see that the drill-through definition button is disabled.
For some unknown reason, Report Studio doesn't allow you to create drill-through from crosstab intersection. You need to select the 'Fact cells' class or the 'Text item' within the intersection. By unlocking the object, we select the text item within the intersection and create a link from there.
Another way is to right-click on the intersection, and to choose 'Select Fact cells'. This will enable the drill-through button and let you define one.