Sort ascending AND descending

primeap · 2013-06-11

Hello
is there a way to sort either ways ascending and descending on different fields of course..

here is an example.
i have this key:
ILE.SETCURRENTKEY("Entry Type","Document Type","Posting Date",Quantity);

I d like to sort all Ascending.

so ILE.ASCENDING(TRUE) would be ok. BUT!

For the Quantity i would like to sort in descending order..

Is this possible or otherwise achieveable?

Best regards

vaprog · 2013-06-11

From within NAV it is not possible to create or use a key like that.

You might be able to achieve it by programming (changing filters and keys as needed in each situation).

It is probably best to create a field with manipulated data that causes your records to be sorted as needed, and create a key on that manipulated field. For descending quantity, you would use the negated quantity to populate the field.

vaprog · 2013-06-11

From within NAV it is not possible to create or use a key like that.

You might be able to achieve it by programming (changing filters and keys as needed in each situation).

It is probably best to create a field with manipulated data that causes your records to be sorted as needed, and create a key on that manipulated field. For descending quantity, you would use the negated quantity to populate the field.

MesutG · 2018-01-19

If you use report, try DataItemTableView properties

Sort ascending AND descending

Best Answer

Answers

Categories