Display the value of an Option field

poppins · 2012-10-24

Hi everyone,

How can I display the value of an Option field???
For example, the code Employee.PaymentMode returns 1, but I want it to display the corresponding OptionString...

How to do that???

mohana_cse06 · 2012-10-24

Did you set OptionCaption for the field in table?

David_Singleton · 2012-10-24

poppins wrote:

Hi everyone,

How can I display the value of an Option field???
For example, the code Employee.PaymentMode returns 1, but I want it to display the corresponding OptionString...

How to do that???

Try

message(format(Employee.PaymentMode));

poppins · 2012-10-24

May be I wasn't clear enough...The value is displayed just fine in the report...
The problem is when I try to display it in an Excel file (I am exporting data to Excel)...

poppins · 2012-10-24

mohana_cse06 wrote:

Did you set OptionCaption for the field in table?

Yes, I did it...

poppins · 2012-10-24

David Singleton wrote:
Try
message(format(Employee.PaymentMode));

Thanks David, it works

David_Singleton · 2012-10-24

poppins wrote:
David Singleton wrote:
Try
message(format(Employee.PaymentMode));
Thanks David, it works

:thumbsup:

Display the value of an Option field

Answers

Categories