COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: benmor on 05 Nov 2008 02:56:33 AM

Title: Condition-based drill-down?
Post by: benmor on 05 Nov 2008 02:56:33 AM
Is it possible to disable/enable drilldown from a condition in a ReportStudio expression?

For example: If (condition1 is null) then ("disable drilldown for" [Item]) else...
Title: Re: Condition-based drill-down?
Post by: blom0344 on 05 Nov 2008 07:45:47 AM
Perhaps you can place the drilldown in a list-column and use a render variable to hide the column itself..
Title: Re: Condition-based drill-down?
Post by: DanSev on 05 Nov 2008 08:08:40 AM
Yes, but not how you are doing it. Unlock the report and select the 'text item' in the column. Then copy it and paste. (While still selecting it). You will now have the item twice in the column. Set up the drill through link on one of the text items (not on the column, but on the text item itself). Then you set the Render Variable of each of the two text items in the column to the condition (one to 'show' while the other to 'hide').