Changing displaying values.

[Srik]

Hi All,

Can any one help in  acheive below requirement.

I had a "status" filed in report which can have below states :
Passed, Rejected, EPayment, Payment, Pending, Inactive

when state is  Passed,Rejected,EPayment, Payement    Status in report should display  as "Active"

Thanks in advance.

Kanth.

[venu4cognos]

use decode

[MFGF]

Create a calculated field for display, which uses either if/then/else syntax or case/when syntax.

eg if (status in ('Passed','Rejected','EPayment', 'Payement)) then ('Active') else (status)

Regards,

MF.