option field on report

madmmadm Member Posts: 92
edited 2006-08-09 in Navision Attain
i have a report which uses GET to get information from another table. The field i am trying to bring through is an option field, and this works. The only problem is i get 1, 2, 3 etc etc rather than the option name.. How do i get the option string through?

Comments

  • PhennoPhenno Member Posts: 630
    madm wrote:
    i have a report which uses GET to get information from another table. The field i am trying to bring through is an option field, and this works. The only problem is i get 1, 2, 3 etc etc rather than the option name.. How do i get the option string through?


    instead rec.optionfield
    try

    FORMAT(rec.optionfield)
  • ClausHamannClausHamann Member Posts: 80
    Change the OptionString property (and OptionCaption) of the field that currrently show the values to the corrent option strings and the field will show the options instead of the values.

    Regards

    Claus
Sign In or Register to comment.