>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?


HI,

Grouping the data in the report won't change the order that the records will appear. (Unlike when you use a GROUP BY in a SQL SELECT).

You will need to order your data before you run the report.