static choice All in value prompt

[sram007]

Hi,
I am having a Gender Prompt which shows Male,Female But the user wants both option such as 'ALL'. It means if i select ALL option both Male & female data should be displayed. So that i have added a text ALL in static choice in Use & Display.& my prompt name is Param1
can u guys help me with the next steps which i have to do...

Thanks in Advance..
Cheers
Dilip

[PRIT AMRIT]

Modify your filter expression:

?Parameter?='ALL'
or
[Data Item]=?Parameter?

Thanks
Prit

[jahnavi]

[dataitem]=?param1? or ?param1?='All'

[melee]

Two options; make the filter and prompt optional so if nothing is chose, they pass both.

Parameter:

Use: F
Display: Female

Use: M
Display: Female

Use: M, F
Display: All

Filter:
[Gender] in #sq(prompt('GenderPrompt','token'))#

[sram007]

Thanks fory your reply guys,
But,
Mele-Im getting some error

PRIT, Jahnvi -

[Gender] =?param1? or ?param1?='All'

This code is validating successfully ,
But,When im clicking All in prompt page i can able to see only column headings.No Data.
Please guide me.
Regards
Ram

[Gopinath]

Check whether the string 'All' in your filter [Gender] =?param1? or ?param1?='All' is exactly identical to your prompt static choice value 'All'