I have a table I am running a report on that groups on the "header1" field.
The table is not sorted at all.

The data looks like:
Header1 Header2
***************
Davanti Bottoni
Davanti Asole
Dietro Fianchetti
Assierne Spale
Assierne Orlo Fonder
Davanit Orlo Fondo


I was expecting that when I group the data would come out as:

Davanti Bottoni
Asole
Orlo Fondo

Dietro Fianchetti
Assierne Spale
Orlo Fonder

But it comes out as:
Davanti Bottoni
Asole

Dietro Fianchetti
Assierne Spale
Orlo Fonder
Davanti Orlo Fondo

What I do not understand is why it doesn't sort when it groups. How come
the last field Davanti field does not come into the correct group?

Shouldn't it?