Displaying option field contents should return

TrippyZ
TrippyZ Member Posts: 87
edited 2008-09-17 in NAV/Navision Classic Client
If I have an option field setup as A,B,C when I display the field in a report I get 1 or 2 or 3.

What do I need to do the get it 'translated' using the option string?
Professional Navision Developer

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    Do you display it in this way: "Table"."field"::"Option" ?

    This way NAV shows it as an integer.
    To avoid it, you should do as follows:
    Put somewhere C/AL code that assigns the option
    "Table"."Field" := "Table"."Field"::"Option"
    and then use "Table"."Field" in the field.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • sre
    sre Member Posts: 62
    I would suggest to use FORMAT(Field), e.g. in the source expression of the text box control. Should work, shouldn't it?

    sre
  • TrippyZ
    TrippyZ Member Posts: 87
    Thanks sra, FORMAT did the trick.
    Professional Navision Developer
  • garak
    garak Member Posts: 3,263
    use format(OptionVariable/Field)

    Regards
    Do you make it right, it works too!
  • garak
    garak Member Posts: 3,263
    arg, press "Preview" instead of Submit ](*,)
    Do you make it right, it works too!

Categories