COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: BMbabu on 16 Aug 2008 02:11:08 PM

Title: Multiple-drill through in crosstab report
Post by: BMbabu on 16 Aug 2008 02:11:08 PM
Hi,
I am facing the following problem in cognos:

I have a crosstab report with one row R and two different columns A and B.
I want to create a separate drill-through for elements of column A and column B. But cognos is not allowing me to do this.Whenever in the drill-through definition i am specifying different targets for these columns,its changing it to a common target report(the one that was selected latest as the target report in some drill-through definition).

How can i create separate drill-through for both the columns each with its own different target report?

Thanks,
Title: Re: Multiple-drill through in crosstab report
Post by: rockytopmark on 19 Aug 2008 04:01:07 PM
use a layout expression, with a CASE statement, that will provide a parameterized URL to do the drill-through.