I have a report that has three levels of groups let's call it:
State - County - City
Then inside the last group (city) is a list of details (perhaps all the zip codes assigned to that city).
Now I want all of the zip codes to be sorted ascending.
I can sort all the states A-Z, all the counties A-z, all the cities A-z, but I can't seem to get any way to sort the detail lines (the zip codes).
How do I accomplish this?