Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Maaseik, Belgium
    Posts
    12

    Unanswered: Sorting values in a report

    Hi all,

    I have a problem, i`ve made a report with all of my values, and i want to sort them by my ID. there is only one problem, the data format is set to the following: !>L0-999;0;_ if i want to sort the ascending, it sorts it as text and i get this order:
    A1-1
    A1-10
    A1-11
    A1-2
    A1-3
    A1-4
    ...
    It doesn't put the 10 and 11 at the end of the list, how can I solve this????.

    regards and thx,

    Davy

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    Two suggestions:

    Include the "high order zero", A01,A02,A03,...A09,A10.

    Or, if you don't want it to show.

    Establish a sequence field A01-A10 for sorting, but don't include it on the report.

    Good Luck,
    Bruce Baasch

  3. #3
    Join Date
    Nov 2002
    Location
    Maaseik, Belgium
    Posts
    12

    Thumbs up

    Thx alot, wil do that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •