User's Grid List Report doesn't sort numbers correctly

  • Profile Image
    AgilityAssoc.Canada
    Asked on March 01, 2018 at 11:42 AM

    One more problem I just found with sorting. there is a column "CAT No" . It to is not sorting as a number but as text.

    It appears, to me at least, that the report creator code needs some tweaking. these reports are could be helpful if the sorting was working correctly.

  • Profile Image
    Richie_P
    Answered on March 01, 2018 at 11:46 AM

    I checked the CAT No but I can't seem to replicate the issue.

    It is sorting correctly at my end.

    Please let us know if you have further questions.

  • Profile Image
    AgilityAssoc.Canada
    Answered on March 01, 2018 at 12:08 PM

    @Richie_P

    To view the problem you need more then 7 submissions. Try with at least 15 to 20 and then try sorting, the issue will then show it's ugly face. You can use my test sheet if you like.

    Robert

  • Profile Image
    Richie_P
    Answered on March 01, 2018 at 12:27 PM

    I followed your instructions and I have replicated the issue.

    It seems that the two digit values are not sorting correctly, the sort only gets the first digit.

    I have forwarded this issue to our second level so that they can check it out.

    We will update you via this thread for any progress on the fix.


  • Profile Image
    NeilVicente
    Answered on March 08, 2018 at 02:04 AM

    Hi Robert,

    This bug should be fixed now.

    Cheers!

  • Profile Image
    AgilityAssoc.Canada
    Answered on March 08, 2018 at 09:49 PM

    Hi,

    Yes it works great, thank you.

    Now if you can the date issue resolved were off to the races.

    Regards, Robert

  • Profile Image
    Nik_C
    Answered on March 09, 2018 at 03:39 AM

    Hello Robert, I wasn't sure about your last reply, if you need anything else attended, please let us know.

    Thank you!