If in V8 reports appear to be sorting only the first portion of what you have set to sort and starts jumbling things together that seem to be related items.
Example I had:
2 different styles
Adrenaline GTS 11
Adrenaline GTS 12
The report was not grouping all teh 11’s together and ll the 12s together. It treated them all as one style. So would Do the 11 then 12 for teh same size atrib combo. EX:
Desc Size Attrib
Adrenaline GTS 11 9 5E
Adrenaline GTS 12 9 5E
Adrenaline GTS 11 10 5E
Adrenaline GTS 12 10 5E
Adrenaline GTS 11 11 5E
Adrenaline GTS 12 11 5E
Check the Field lengths for the items in sort. Appears that Sorting only looks the number of characters specified in Field lengths when deciding sort order. I Upped it from 15 to 20 and started sorting/Grouping together.