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
Modify your filter expression:
?Parameter?='ALL'
or
[Data Item]=?Parameter?
Thanks
Prit
[dataitem]=?param1? or ?param1?='All'
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'))#
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
Check whether the string 'All' in your filter [Gender] =?param1? or ?param1?='All' is exactly identical to your prompt static choice value 'All'