we have a condition like
case when 'O' then OPEN
case when 'N' then NEW
case when 'C' then CLOSED
case when 'U' then CLOSED
we have been asked to display
if user select 'O' then report should show
both OPEN and NEW (if esxist)
is there anyway to resolve.
kindly thankyou in advance
Pooja,
Try resolving by applying a case filter.
When 'O' then (field in ('OPEN','NEW')
Hope this helps,
Jeff