I have a sub summary layout that needs to be sorted by year AND I would like it to then be sorted by date inside of the years. I can do this with the sort command, but I would like to do it by script trigger "on layout enter" the problem I am having is that it sorts by year, then throws that out in preference of sorting by date - it does not do both like the sort command will. What am I missing in my script?
the script is
Sort Records by Field [Descending] ; Job Totals::Year
Sort Records by Field [Descending] ; Job Totals::Date