Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Reports and sorting order

Reports and sorting order

Last post 03-26-2013 8:03 AM by Method_Ashur. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 03-25-2013 8:32 PM

    Reports and sorting order

    Reply Contact

    Greetings,

    I am trying to make a list of irrigation stations in number order.  

    method is doing the follwing:

    Station 10

    Station 11

    Station 12

    Station 1

    Station 2 

    Any ideas?

    Thanks!

    John M

  • 03-25-2013 11:34 PM In reply to

    Re: Reports and sorting order

    Answer
    Reply Contact


    Hi John-  All computers read numbers stored as text from left to right, so you would need to use a leading zero for each single digit station number to get them to sort correctly with the double digit numbers.  

    Station 01

    Station 02

    Station 10

    Station 11

    etc. 

    If you will have more than 99 stations, use 001, 002 ... 010, 011, 012 ... 100, 101, 102, etc. so that all of the numbers will have three digits.

    Hope this helps!

    -Mary

    -Mary Longacre

  • 03-26-2013 8:03 AM In reply to

    Re: Reports and sorting order

    Reply Contact

    Mary - Thanks for the help!

    John - Let us know if you require further assistance.

    - Ashur

    Need more help? Ask us about Method consulting services

    Ashur Shamon
    Lead Solutions Specialist, Professional Services
    Method Integration Inc.
    www.method.me
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: a.shamon@method.me
Page 1 of 1 (3 items)