List in Designer

[Latyr]

Hi

One of my dimension can have the following values :
X --> unavailable
A --> available
D --> Delete

What should I do in Designor if I want my users (reporter) to see the values Unavailable, Available or Delete ?

Thanks for your help and support

Latyr

 

[nimmy99]

Edit your lov file with replace function

 

[Latyr]

How can I do that ? Would you mind giving a bit more informations ???
Thanks in advance

 

[nimmy99]

CAse object
x = replace(object, x , unavailable)
a = replace(object, a, available)
d = replace(object, d, delete)
end

This is the logic but you have find out the correct syntax according to your Database type (ie. Oracle, SQL Server, Access)

 

[Sridharan]

CASE WHEN Object = 'x' THEN 'UnAvailable'
     WHEN Object = 'a' THEN 'Avaialable'
     WHEN Object = 'd' THEN 'Delete'
END

Sri