option field on report

madm
madm 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

  • Phenno
    Phenno 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)
  • ClausHamann
    ClausHamann 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
    Claus W. Hamann

    http://www.AcumenConsulting.co.nz

Categories