No. of list option in option type

vijay_g · 2011-07-20

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

mohana_cse06 · 2011-07-20

Why do you want the Count?

vijay_g · 2011-07-20

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

mohana_cse06 · 2011-07-20

vijay_g wrote:

i want to show data in column by option type.

Can you explain with one example?

vijay_g · 2011-07-20

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 · 2011-07-20

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

vijay_g · 2011-07-20

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

mohana_cse06 · 2011-07-20

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 · 2011-07-20

No i am working on classic anyway thanks.

MBerger · 2011-07-20

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 · 2011-07-20

i got it with recref.
thanks a lot.

No. of list option in option type

Comments

Categories