Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Needs review
Categories General
Created by Guest
Created on Sep 20, 2023

report with correct 1-9 numbering

I want to be able to create a report that displays the correct numbering system. ie 50mm

60mm

84mm

90mm

100mm

115mm

125mm

130mm

138mm


as it stands it ignore the values and groups them by the first digit

100mm

115mm

125mm

130mm

138mm

50mm

60mm

84mm

90mm

  • Guest
    Reply
    |
    Oct 26, 2023

    I agree as well, though the issue may be more than just Bentley. I commented on a similar idea in Civil Ideas.

    BCI-I-1047

    "I see this in more than just ORD. Windows does this at times as well. But I would like to see it too!

    Sorting sometimes is not looking at the entire word or string, but sorting the first character of each entry, then the second, etc. That is why we get P1, P10, P11, P12, --- P2, P20, etc.

    Without getting Microsoft to change as well, should be easier to have ORD 'pad' the numbers with 0's for sorting, just need to be able to choose your desired number of digits in the software (or in Civil settings, like a decimal accuracy). Then you would get a list of P001, P002, P003, --- P010, P011, --- P100, P101, etc."

  • Guest
    Reply
    |
    Sep 26, 2023

    Couldn't agree more!
    Current workaround is to use leading zero's in the (string) property. So 060mm instead of 60mm => then it will sort correct.