the static choices are:
display - use
Group A - 0
group B - 1
All Groups - 0,1
I can't send the All Groups value... :-[
Hi,
I don't think you can do this. Instead, you will need to be a little more creative with your filter:
Set your prompt's static choices to be:
Display - Use
Group A - 0
Group B - 1
All Groups - 99
Then in your filter, use an expression such as:
[Group code] = ?Your param? OR 99 = ?Your param?
Regards,
MF.
You should be able to use that.
Instead of using a prompt alias (that's with the question marks), use a token prompt.
Try [Group Code] in (#prompt('Your Param','token')#)
Although I am a little surprised the alias didn't work. Are you sure you were using the in operator instead of the =?