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