In this recipe, we will learn about a limitation of drill links and how to overcome it using Render Variable.
Let's say there is a crosstab report which shows sales quantity by month and order method. We need to provide a drill-through facility from the intersection. However, the drill-through target needs to be different depending on the order method.
If the order method is e-mail, the drill-through from the intersection should go to a report called Alternating Drill Link—Drill Report 2. For all other order methods, it should go to Alternating Drill Link—Drill Report 1.
Create a crosstab report to serve as the main report. Drag Month key (ship date) on rows, Order method type on columns and Quantity on the intersection. ...