If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

opening 2 drill thru reports from a single column

Started by Shailaja0520, 23 Mar 2009 05:32:48 AM

Previous topic - Next topic

Shailaja0520

Suppose i have a column with static values-- A and B

Drill thrus should be in this way-
Clicking on A should open the child report -Report1

Clicking on B should open the child report -Report2
Can 2 target reports be linked for the same column..

Thanks

DanSev

If A and B are in the same column, but are different items you can set up the drill through property on the text item within the column (unlock the report).
Additionally, you can set up 2 drill throughs on the column itself, and when a user clicks for a drill through, they would get a menu of the reports they can drill to.

rockytopmark

You can use a Layout Expression that will in essence be a hyperlink.  The URL will be built in the expression and you can incorporate a CASE statement based on your desired data item, to determine which report is in the URL.  You can also pass parameters to the drill-through report in the URL, which is generally a requirement in drilling through.