In case its not a typo, try grouping by header1, header2 in a SQL statement as Mark suggested, and then make it a source for the report.


>Sorry the formatting here is better for clarity
>
>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?