COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: suri.cognos on 04 Aug 2016 05:47:45 AM

Title: Filter the same data item with multiple prompts using single prompt page
Post by: suri.cognos on 04 Aug 2016 05:47:45 AM
can we Filter the same data item with multiple prompts using single prompt page

Please Help me
Thanks
Title: Re: Filter the same data item with multiple prompts using single prompt page
Post by: MFGF on 04 Aug 2016 06:40:46 AM
Quote from: suri.cognos on 04 Aug 2016 05:47:45 AM
can we Filter the same data item with multiple prompts using single prompt page

Please Help me
Thanks

Hi,

Can you explain how it could make sense to filter a single item from multiple prompts? I can't picture a scenario where this is valid? Can you describe what you're trying to do?

MF.
Title: Re: Filter the same data item with multiple prompts using single prompt page
Post by: BigChris on 04 Aug 2016 07:00:21 AM
I could imagine the user wanting a number of date ranges for example. So you might have a filter that looks something like:

([DateField] between ?pStartDate1? and ?pEndDate1?) or ([DateField] between ?pStartDate2 and ?pEndDate2?) etc.