Quantity Sorting

roshini

Hello Experts!!

I am unable to sort quantity field, can any have idea how to sort quantity field.

My data is a shown in image.

I am trying Qunatity for Top 3 Sale Items.

My Code:

Top2.RESET;
Top2.SETCURRENTKEY(Quantity);
IF Top2.FINDFIRST THEN
"Top Item 1" := Top2."Item No.";

Can expect any help??

David_Singleton

Create a new Field "Quantity Int" type INTEGER. Add a keyon this field. then create code that will do something like

Calcfields(quantity);
"quantity Code" := round(quantity,1);
modify;

run this each time you need to sort.

roshini

Thanks a lot David for quick response!

This is table. Not form. data will be updated in this table. I need to show top 3 items in separate form, that is not related to this table.

in table is it possible to sort??

Ravi_Thakkar

If Quantity is a field from the Table then add that Quantity Field in Key List of that Table as secondary key.
And then after you can use your code on occuring of required event.

Hope this would help you.

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

roshini

Hi Ravi,

u hv not seen my query properly, I already created Key, code also there in my query.

or If I want to store the data in sorting order any posibility is there??

dayakar

Hi,

If you want to sort based on the table field itself,

Maintain a new key (Some thing like Priority field in the Vendor table) as david suggested then update that field on each insertion or quantity update.