Am I missing something or does the sort in subreports not fuction normally ? Running the subreport lists in physical order. Go into the subreport and select sort and change to descending and it works - change to ascending it works run again and back to physical order. (CR7)