I have an Active report with 3 Lists with columns,
Class | Year | Qty <- higher level
SubClass | Year | Qty <- lower level
Class | Month| Qty <- lower level
[I am trying to develop a drill down in active report]
Is there anyway I can target the lower level list, according to the column on which the user clicks.
i.e. If user clicks a certain Class in 1st list , then the 1st list then list with Subclass | Year | Qty is shown
whereas if the user clicks Year value in the 1st list , the list with Class | Month | Qty is to be shown.
So, in summary I will have to know which column the user clicked on.
Hi,
You will have toachieve this by using data decks, when you click on the parent table it will be replaced by the table in the deck of child.
Same sample is given in IBM samples. Please refer the following link
http://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html
Regards,
Rahul