static choice help

[pooja]

suppose in static choice there are two choices:
O = OPEN
C = CLOSED

now how it is possible to acheive another selection for B = BOTH (to show OPEn as well CLOSED)

thank you in advance

[kattaviz]

Hi
You can try B=Open,closed

HTH
Satish

[pooja]

this is what we are trying to achieve

CASE    
WHEN
DEPT_STATUS = 'C' then 'CLOSED'
WHEN
DEPT_STATUS = 'O' then 'OPEN' 
ELSE

'NA'
END
DEPT_STATUS,

here, how to achieve both 'C' & 'O' at a same time by using 'BOTH'

[kattaviz]

Hi

Do not do this calculation in the Report. Create 3 static choices in the prompt itself.

Use Value             Display Value
C                         Closed
O                         Open
C,O                      Both                         

[MFGF]

Hi

Do not do this calculation in the Report. Create 3 static choices in the prompt itself.

Use Value             Display Value
C                         Closed
O                         Open
C,O                      Both                         

Agreed.  You will need to code the dependent filter to use the 'in' operator rather than '=' too.

MF.