I need to set-up a report to be sorted by the values in fields with 3 repetitions. So far it works fine but it only sub-summary sorts the values on the first repetition. Any idea how to fix it!

[i have a list of office numbers and each receives one or more newspapers. I need to have it report what office numbers receice newspaper 1, 2, etc. The Newspapers are on a drop list that is assigned to the newspapers field (3 repetitions) I need it to list the office numbers by Newspaper.]

The only way to fix it is to split the repetitions into related records, then generate the report from the related database.

This is exactly why you should not be using repeating fields. Create a true relational design. You cannot individually sort, select, or delete repeating fields. Filemaker went relational with version 3 and repeats were obsolete then except for special purposes and this isn't one of them.