Hi all - I am using CR XI.

I have a group that I wish to sort, and using the Record Sort Expert, I select the group and a field (say TASKS.WO_NUM) and this works fine. But when I add a secondary sort (say TASKS.DUEDATE), nothing happens. The primary sort field (WO_NUM) remains sorted, but the secondary sort field is unchanged (I even toggled the ascending/descending option, to no avail).

I've done this a dozen times before, even sorting 4 or 5 fields, but for this particular report, I cannot get the secondary sort to work. I was just wondering if there is something happening behind the scenes that I don't know about, or some other known cause for this? And it isn't just the TASKS.DUEDATE that won't sort - it's all fields (I've selected all of them). I've even changed the primary field and that worked, but no secondary field will sort.

Any pointers would be helpful. Thanks!

Personally, the sort feature doesn't make much sense to me.  I just add another group, which forces the sort.  If I am using it for sorting, I suppress the header and the footer.

Hmmm - so you are saying that the Sort feature is buggy when it comes
to nesting, huh? OK - I will try to get around this by using multiple groups instead. But I swear this was working perfectly before. I've written about 12 report with layered-sorting and they all worked. I have no idea how I suddenly just broke them all by undoing and redoing the sorts. Maddening.
I am wasting so much time on cosmetic crap!

True - it may be have been something unrelated that was responsible. For instance, on one report, I decided to click on "Database Expert" and add another table, and when I did this I got a warning when I OKed it saying that there were "too many complex links" (or something like that) and that they did not recommend that. I later went back in there and removed those links (as I didn't need them indexed). So perhaps it is something like this that overwhelmed the nested sorting. I am brand new at this and have no training at all, so I really can't say.