Set User Selection with Parenthesis

[Rauf]

I have read documents on Oracle My Support regarding the subject. It leads to dilemma.

How can I specify the following condition in a report ?

Active=0 AND (ID_No=<Blank> OR Expiry_Date > SL DateToDay)

 

[newjdedev1]

I think this should be done as below

Set user selection (Active, <Equal To>, <Zero>, <And>)
Set user selection (ID No, <Equal To>, <Blank>, <And>)
Set user selection (Active, <Equal To>, <Zero>, <Or>)
Set user selection (Expiry Date, <Greater Than>, SL DateToday, <And>)

 

[Serge_Lagace]

IF Active = 0
AND ID_No = <Blank>
OR Active = 0
AND Expiry_Date > SL DateToDay)

 

[El Vic]

Hi Rauf,

Have you had a positive result???. I'm having the same problem with a User Selectio Condition. I would need put a right parenthesis ) to close a AND condition !!!.

Any help I will apreciated!.