0

Sort by Numeric Value

Jet Reports Historic Posts

July 19, 2016 15:15

None

Follow

I'm creating a report using Dimension Value and the Sorting is by first number (1, 10, 13, 14, 2, 20, 25)

I need them to sort by numeric value (1, 2, 10, 13, 14, 20, 25)

Is there a way to accomplish this?

Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 25, 2016 21:52

  Hello.
  
  I have to assume you are using Dynamics NAV.
  
  Different versions of NAV can sort certain fields in different ways. This is most common in fields which can contain both numeric and non-numeric values. NAV knows 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 Professional 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.