1 Reply Latest reply on Jul 1, 2013 5:18 AM by ninja

    Problems with sorting in reports

    JoanneGoldberg

      Title

      Problems with sorting in reports

      Post

           I'm creating reports for a database I've just finished and regardless of whether or not I select 'sort' and 'sort ascending' for a single field on the report assistant, my records are not sorting in ascending order.  Any ideas?

        • 1. Re: Problems with sorting in reports
          ninja

               Are you sorting via script?  Manually?

               Look at the field after sorting...is there some order to it that may be explained by the field being a text field when it should be a number?

               FWIW, text sorts numbers differently than numbers do...for example:

               1

               10

               11

               2

               20

               21

               etc...