Parameter Query

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

Question,
I have four regions. AP,JP,EU,NA. I want to create a
parameter that prompts the user to type what region they
want. I'm able to do a parameter that one can select one
region and also one that selects all regions, but how can
I do one that you can select upto two regions.
Example if I do a between I will get all, but maybe I just
want AP and JP. I been trying but can't seem to get.
So can anyone give me some pointers?

Appreciate any help.
thanks,

juan
 
Well, one way

Field: Region
Criteria: In ([FirstChoice],[Second Choice])

That should work. You will get two prompts and can enter one or two values.
 
Hello John,
thanks I will try this.

Juan
-----Original Message-----
Well, one way

Field: Region
Criteria: In ([FirstChoice],[Second Choice])

That should work. You will get two prompts and can enter one or two values.
Question,
I have four regions. AP,JP,EU,NA. I want to create a
parameter that prompts the user to type what region they
want. I'm able to do a parameter that one can select one
region and also one that selects all regions, but how can
I do one that you can select upto two regions.
Example if I do a between I will get all, but maybe I just
want AP and JP. I been trying but can't seem to get.
So can anyone give me some pointers?

Appreciate any help.
thanks,

juan
Click to expand...
.
Click to expand...
 
Back
Top