Apply simple case statement

[sekar211]

I have table in which has a column "active" and the values are either 'Y' or 'N'. But on the report i have to field called 'Status' which displays like 'Active' or 'Not active' but not 'Y' or 'N'.
In order to achieve this can i use "apply simple case statement REPLACE" with in the Status attribute and display 'Active' or 'Not Active' based on 'Y' or 'N' in the table?
I am not sure if we can do this.If not is there any other way we can achieve it?

Thank you.

 

[nlim]

create an attribute called status. Use the case statement in the description form of the attribute. something like case(active='Y', 'Active', 'Not active')

no need for applysimple.