COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mitwa on 28 Jan 2014 04:12:52 AM

Title: need to add filter to get output only for selected item of second report
Post by: mitwa on 28 Jan 2014 04:12:52 AM
i have 2 prompt page.. one prompt consists of product line and product type..if i select product type in prompt1 then related details will display on prompt2..same as that for also product line...

till above step i have completed but i need to add filter to get output only for selected item of second report..

output will be like     ROPE   3000  only..but i am getting output of all
Title: Re: need to add filter to get output only for selected item of second report
Post by: MFGF on 28 Jan 2014 05:25:56 AM
Hi,

If you are getting too many rows returned in your report it points to one of your filters being incorrect. Can you take a look at your filters and see how they are defined? If you can't figure oot what the issue is, you will need to give us more details about how your filter expressions are currently defined and what you want them to do differently.

Cheers!

MF.
Title: Re: need to add filter to get output only for selected item of second report
Post by: mitwa on 28 Jan 2014 05:40:00 AM
Hi, till now i have not mentioned any filters..thts y m getting all rows..i need to filter it for only one..

now output is look like            ropes  3000
                                               ladder 3400
                                                climp 2456

but i require like                      ropes  3000
Title: Re: need to add filter to get output only for selected item of second report
Post by: MFGF on 28 Jan 2014 06:40:28 AM
Hi,

Is this data two separate items or one item? If it's two items, add a filter on the first item such as

[your first item name] = 'ropes'

If it's a single item, your filter would be something like this...

[your item name] starts with 'ropes'

Cheers!

MF.