Sorting integers incorrectly by character

(6 posts) (2 voices)
  1. jforrest, Blocked

    I have a column in my report that is an integer, but when you click on the header to sort it, myDBR is sorting the values as if the integer is a string. I.e.:

    1
    1
    1
    1
    10
    11
    12
    13
    2
    20
    21
    21
    3
    30
    etc...

    The strange thing is that I have another column that is almost identical (also numeric), which myDBR sorts correctly.

    What could be causing this problem?

  2. myDBR Team, Key Master

    Hi,
    Do you have nulls in the column or anything else in first row that might cause this? myDBR looks into the data to determine which sorting algorithm it will use.

    --
    myDBR Team

  3. jforrest, Blocked

    There are nulls in the column, but other columns with nulls are sorting correctly. The column type is int so there isn't any way there's anything other than nulls in the column.

  4. myDBR Team, Key Master

    Hi,
    What is the content in first row of that column before the sorting is done? Is that data null?

    We do have an improved datatype detection for these cases in the upcoming release.

    --
    myDBR Team

  5. jforrest, Blocked

    Yes, the first column is null in the first row before sorting is done. Is there any workaround available until the upcoming release?

  6. myDBR Team, Key Master

    Check your mail.

    --
    myDBR Team


Reply

You must log in to post.