2 Replies Latest reply on Feb 13, 2017 7:45 AM by philmodjunk

    Second level sorting

    lukeingram

      Hi,

       

      I have a report layout that has a sub summary when sorted by part. The sort is triggered from a script when the layout opens to ensure the sub summary part is always used. I would like the data within each sub summary to be sorted by another field, is this possible?

       

      Thanks

      Luke

        • 1. Re: Second level sorting
          mikebeargie

          yes, just add two fields to the sort records script step or dialog box (ctrl/cmd + S)

           

          If you add the subsummary field first, then the records inside of the subsummary will be sorted by any field(s) after that.

           

          EG:

          Company Name

          Last Name

          First Name

           

          In a subsummary by Company Name would return contacts, grouped by company, sorted by LastFirst name order.

          • 2. Re: Second level sorting
            philmodjunk

            To add to Mike's answer, there are two different script steps that sort records. One only allows you to sort on a specified field, it replicates choosing a sort order from a column header in table view. The other script step, Sort Records replicates sorting as it works from the Records menu. It uses the same dialog for setting up your sort order and thus you can sort on more than one field.