Hello, Everyone!
I'm trying to figure out how to get numeric results to sort in actual numeric order, not by the first digit. When we updated our NAV version recently, that was the first time we saw results sorted that way.
Is there a way for the results to be sorted in numerical order in JetReports (and in NAV for that matter).
Thanks for your help!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi -
As you have discovered, different versions of Dynamics NAV can sort certain fields in different ways. This is most common in fields which can contain both numeric and non-numeric values. NAV know that the field can contain both, so it performs a "textual" sort ("10" < "100" < "2") rather than a numeric sort ("2" < "10" < "100")
It is also possible (depending on the version of NAV) that the server type will have an impact (a Native NAV server will sort differently than a SQL server).
In a Jet Essentials report, it *might* be possible to force NAV to sort numerically. Try something like this:
=NL("Rows","table_name","field_name","+field_to_sort_by","NUMBER&*")
The use of the the NUMBER& in the filter may force NAV to recognize your sort field as a numeric value.
Please sign in to leave a comment.