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
Hi
You can try B=Open,closed
HTH
Satish
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'
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
Quote from: kattaviz on 12 May 2010 03:11:02 PM
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.