Option Data Type

I have a field in a table called Height, datatype is option. Values are High,Medium,Low. In report when i am printing that field it is showing 0 for high, 1 for medium & so on. Means it is showing respective integer position. How can i deal with this problem? Thank You.

Check the OptionCaption and the OptionCaptionML properties of both the field on the table and the textbox on the report.

FORMAT(Option,0,'<Text>');

By the way, soumyadip:

quote:

General comments and suggestions to the Microsoft Business Solutions User Group. Debates that are not website - but user group specific.

This is the description of this forum. You are posting in the wrong forum, better would be NAVISION DEVELOPMENT.

[B)] where should i post? Please tell me the full name of the group.

Group: Navision (aka Financials / Attain) Forum: Navision (Attain/Financials) - Developer Forum Description:

quote:

Questions and discussion about development and modifications in Microsoft Business Solutions Navision Edition (formerly Navision Attain and Navision Financials).

Link: http://www.mbsonline.org/forum/forum.asp?FORUM_ID=9

quote:

I have a field in a table called Height, datatype is option. Values are High,Medium,Low. In report when i am printing that field it is showing 0 for high, 1 for medium & so on. Means it is showing respective integer position. How can i deal with this problem? Thank You. You can use the OptionCaption property to define what to display.
Originally posted by soumyadip - 2004 Nov 04 : 08:17:07

Moved by admin