Creating dynamic filters for report

[orbair]

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.

[Raghuvir]

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

[orbair]

This is solved , thanks Raghuvir