Skip to Content
0
Former Member
Dec 12, 2011 at 01:47 PM

Proper numebr sorting in BO XI Web

36 Views

Hi all,

I have a slight sorting issue with the WEBi (XI). I have a report written in DESKI, which is sectioned by an Employee number. This is then sorted by Employee number (Asc), so that I get a list which goes like this:

1, 2, 3...100, 101,102...1000,1001...

I then converted this report to WEBi, and whereas the conversion went well overall, the sorting seems to be broken, as the order in WEBi is now:

100000, 100001, 10002...101, 102, 103, 21, 22, 23, and so on, meaning as far as I can understand it that the WEBi is not reading this as an actual number, but rather as a string of digits.

I've of course made sure this number is in Number format, but this seems to have no affect.

And ideas please?