Hi,
I have a report with a number of crosstabs that count various things - such as employees in a certain age, length of service, qualifications etc. The structure of the counts is similar to this - this is a data item that I'd use to count people approaching the end of their career.
count(
if([Age] >60) then (1) else (null)
)
Now, if I put this into a crosstab or a pie chart and try creating a drilldown on "Employee ID" each time it gets to the target report it prompts me to select the ID. The target report does have a filter like [Employee ID]in?EmpID? in place to capture multiple values.
Is there something I'm missing?
Thanks, Chris.
Hi Chris,
I wonder if you are passing the correct parameters, if you are creating a drill through on the count make sure you set EMP ID in Properties for the values to be part of parameter to be passed.
Thanks,
RK
To help debug drill-throughs, right-click the drill-through source link and pick "Goto > Related Links", which should list your drill-through target report(s) in a dialog. If you have sufficient Cognos capability permissions, you will have an option to the lower right of the list to "View passed source values". The report link itself will also have a drop-down for "View Target Mapping". This can help you see what is actually being passed to the target report.