COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Pramod on 11 Mar 2010 01:19:37 AM

Title: Passing multiple values in drill through
Post by: Pramod on 11 Mar 2010 01:19:37 AM
Hi All

I have a report with one column Product Name. I apply a summry called count at the end which gives the count of report. I filter the report using  a parameter which filter as( Product Name starts with ?Param?)

I then apply a drill through on Count data item but pass the Product Name to the parameter in the target report.I get only the first Product name in target report. Say I filter product name for 'B' and there are 19 values for this filter. First value is say Beer so in target report shows only detail for Beer and not for remaining 18 values.


Any help or reasoning will be appreciated
Title: Re: Passing multiple values in drill through
Post by: IceTea on 11 Mar 2010 03:41:53 AM
Hi,

first idea from me is not to pass the product name to the target report. Instead pass the parameter value (for example 'B') to the target report, where you have to change your filter criteria to deal with this. So you should get additional results, given that the target reports filters on same data as the source report.