No. of list option in option type

vijay_g

hi,
How can i count total listed option in option data type?

mohana_cse06

Why do you want the Count?

vijay_g

i want to show data(in report) column by option type.

mohana_cse06

vijay_g wrote:

i want to show data in column by option type.

Can you explain with one example?

vijay_g

i have a field location type in location table. now i wanna show total inventory along with location type.
a location type can have multiple locations assigned.

mohana_cse06

If you need it in Report, you can develop a report by Grouping on Location Type ..

vijay_g

but the format is location type should be comes column wise.
isn't any function to count no. of option?

mohana_cse06

If you need it in RTC, follow this blog
http://blogs.msdn.com/b/nav/archive/2009/08/28/building-a-matrix-report-in-microsoft-dynamics-nav-2009-sp1.aspx

vijay_g

No i am working on classic anyway thanks.

MBerger

Using RecordRef and FieldRef you can get the optionstring and optioncaption strings of a field, and using some string functions you can determine the number of the options within it.

Following example will show you the options of the field "costing method" of the item table :

Variables : recref = Recordref, fref = fieldref ;

recref.open(27) ;
fref := recref.field(21) ;
message(Fref.OPTIONSTRING) ;

vijay_g

i got it with recref.
thanks a lot.