O'Reilly logo

IBM Cognos 10 Report Studio Cookbook - Second Edition by Abhishek Sanghani, Ahmed Lashin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Alternating drill links

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.

Getting ready

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required