General information
Category:
Coding, syntax & commands
Title:
Calculated expresion in Grid column Control Source too long
Hi All,
I am trying to put Calculated Expresion in Grid Column Control Source but it
is too long.
i.e.
iif(job_status_2='0','Dispatched',iif(job_status_2='1','Accepted',iif(job_st
atus_2='2','Rejected',iif(job_status_2='3','Attended',iif(job_status_2='4','
Commenced',iif(job_status_2='5','Work
Suspended',iif(job_status_2='6','Recommenced',iif(job_status_2='7','Complete
d',iif(job_status_2='8','Created',iif(job_status_2='9','Waiting for
Dispatch',''))))))))))
I want to display to user Description instead of value 0,1,2,3 etc...
Is there any other way to do what i want to achive?
Regards
Dejan
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only