COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 18 Jun 2012 12:01:35 PM

Title: How to get Deail report by clicking particular EMP NO
Post by: barrysaab on 18 Jun 2012 12:01:35 PM
I have about 12 employees whose no of leaves are available in next column,My requirement is when end user click the particular alert the particular employee no  detail report should be opened.I have think about drill through but drill through is applied on whole column,I am unable to think how to go about this one.Appreciate your help a lot.Thanks
Title: Re: How to get Deail report by clicking particular EMP NO
Post by: blom0344 on 18 Jun 2012 02:19:36 PM
Drillthrough can be applied to the Id that is chosen from the main report! You then simply pass the value from the dataitem to the child report..
Title: Re: How to get Deail report by clicking particular EMP NO
Post by: bi4u2 on 25 Jun 2012 08:22:50 AM
Barry, set up a drill through to a child report. If no data is available for a particular employee, put something on the 'No Data' property that says 'No detail available for the selected employee'.