I have a report that is sorted by date. (Col 1)
then comes location. (Col 2)
The problem arises when there are two locations on the
same day.
I need the locations listed chronologically, alpha sort won't help.

Location        Date           Info
Town A            1/1/2012
Town A            1/2/2012
Town A            1/3/2012

Town B             1/2/2012
Town B             1/3/2012      (what I need)

(I am getting)
TownA              1/1/2012
TownA              1/2/2012
TownB              1/2/2012

TownA               1/3/2012
Town B              1/3/2012

Sorry, I didn't make the problem clear.
Towns are (eg)
New York        Jan 1
New york        Jan 2

Albany            Jan 2
Albany            Jan 3

Scotland          Jan 4     etc.

If I sort the town I get them in alpha order, instead of
chronological.

Any information on your desired result using my sample data, Stew?

OK, I see what you're after. I've built reports like this, but it can't be done simply by sorting. You are looking to find the lowest date, then pick out all the records for the city matching that date, then move on to the record with the next lowest date that has not already been picked out. That's much more complicated than an ascending value sort. You can do this with the XResultSet commands, but it will involve building the report entirely in SBasic and emitting the final result. 

What is the purpose of having the records presented in this way? Perhaps the requirement can be solved in a less code-intensive way.

If not, this is doable, but you'll need to roll up your coding sleeves.

Make a hidden field for temp sort sequence number.

Take original list of locations and dates, sort by date, remove lines with duplicate locations. 

Now, assign an incrementing number to each line in order to use as a temp sort value. 

Now mass update the original list, assigning the same number to all the duplicate locations in the temp sort sequence field. 

Now you can do a final sort by tempsort sequence number, and date. Run your reports.

When done, clear out the temp sort field for future use.