Optional/Required prompt

[MFGF]

Added on behalf of Joker.

Joker asked:

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page.
I want that if I select nothing from the prompt list then nothing is displayed in my report page.
How should I do this?

Regards,
Joker

If you set the filter to Required, the user cannot progress without selecting a value from the prompt on the prompt page. If, on the other hand, you set the filter to Optional, the user can completely bypass the prompt (and therefore the filter) and see unfiltered data. These are your two options.

I think your best bet is to leave the filter as Required so that the users cannot press OK without selecting a prompt value.

Cheers!

MF.

[Joker]

Hi,

Actually i have two cascade  prompts in my prompt page for two lists(having different data) in the report page.If I select values from one prompt and don't want to display the data in the other list  if I am not selecting the values from the second prompt.
how can I achieve this?
I want that the second list is not displayed if i am selecting no data from second value prompt.

Thanks in Advance.

[Joker]

If you set the filter to Required, the user cannot progress without selecting a value from the prompt on the prompt page. If, on the other hand, you set the filter to Optional, the user can completely bypass the prompt (and therefore the filter) and see unfiltered data. These are your two options.

I think your best bet is to leave the filter as Required so that the users cannot press OK without selecting a prompt value.

Hi,

Actually i have two cascade  prompts in my prompt page for two lists(having different data) in the report page.If I select values from one prompt and don't want to display the data in the other list  if I am not selecting the values from the second prompt.
how can I achieve this?
I want that the second list is not displayed if i am selecting no data from second value prompt.

Thanks in Advance.

[bi4u2]

Joker, what if you add a static value to the prompt that is just an empty string '' or says 'No Selection' ?

[MFGF]

Joker, what if you add a static value to the prompt that is just an empty string '' or says 'No Selection' ?

Yep - my suggestion too.

MF.

[Joker]

Yup :P
Thanks bi4u2 and MFGF..