Drilling on a count

[Chris_]

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.

[RKMI]

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

[bdbits]

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.