All,
Has anyone achieved the following (in Cognos 10.2.1): Drill through capability on column A based on the entry in column B, where column B is a Boolean value ("yes" or "no"). If cell in column B is "yes" then the cell in Column A should be drillable. If column B is "no" then remove the drill through functionality (Link to child report).
Any advice or assistance is much appreciated.
Here's a possible approach:
- Unlock the report and copy <column a> inside the same list column so you see it twice inside the column.
- Put a drill through definition on one of them and leave the other one without any drill through definition.
- Set an advanced conditional style on the one with the drill through using an expression something like: [column b] = 'no'
- Within the above conditional style, set the box type to none (on the advanced tab) for that expression leaving remaining values style as is.
- Do the same two steps above for the one without the drill through, hiding for the case when column b is 'yes'.
Works like a charm!!! Thank you Lynn!!! :D