Dynamic Prompt

[nikol]

Hi,
Is it possible to use two Dynamic Prompts with (EITHER-OR) in a report.
EITHER
( Parameter_name1-- Country/Region/city
COUNT Clients for particular City)
OR
(Parameter_name2-- Country/Region
COUNT Clients for particular Region)

 

[nikol]

I was using
SELECT EXPERT {Command.name=parameter1_name}
Now I have one more parameter2. can I use another parameter2 in SELECT Expert I tried ("one of them") but not working. I'm trying to use Either parameter1 with promptr OR parameter2 with prompt.
Can somebdy plz help me

 

[TedLiu]

Hi,

Please tell us your version, db info and details why is not working.

go to selection formula to check the code there which will have the code generated by selection expert, or try below formula:

other conditions
and
(
{yourtable.fieldname1} = parameter1_name
or
{youtable.fieldname2} = paramter2_name
)

Hope it helps.

Ted