Problem sorting report via portal field
I am attempting to alphabetically sort a report (layout: Roster, table: Office) by a field in a portal (table: Dentist). For some reason it's not sorting properly. It does rearrange some of the records, but not in any order I can tell.
The field is a calculation (Name_Last & ", " & Name_First). The portal is filtered to only show the main conact (by way of a dropdown selection from a value list on the Dentist table).
Any help would be appreciated.