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

    Second level sorting




      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?




        • 1. Re: Second level sorting

          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.



          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

            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.