COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: orbair on 11 Jun 2014 12:06:36 PM

Title: Creating dynamic filters for report
Post by: orbair on 11 Jun 2014 12:06:36 PM
Here is the situation:

I have a list which use Query1. I have 2 value prompts product line and product, cascade source. The client wants to see only those products who are on the list, however I put Query1 to value prompt product, some values are missing. Did anyone faced this problem? thank you for your help

R.
Title: Re: Creating dynamic filters for report
Post by: Raghuvir on 13 Jun 2014 02:32:01 AM
Quote from: orbair on 11 Jun 2014 12:06:36 PM
Here is the situation:

I have a list which use Query1. I have 2 value prompts product line and product, cascade source. The client wants to see only those products who are on the list, however I put Query1 to value prompt product, some values are missing. Did anyone faced this problem? thank you for your help

R.

Hi orbair,

u have assigned query one for your list. assign different query for your prompts. for eg. for promt for product create a new query as Query2 and for product Query3.

apply the filter conditions for prompt in query1 i.e. your list query.

if you are selecting single values in the prompt, then turn on the Auto submit property of the prompt to yes.

feel free to contact if u still facing any issue.

Regards
Title: Re: Creating dynamic filters for report
Post by: orbair on 25 Jun 2014 11:51:24 AM
This is solved , thanks Raghuvir