Hi!
This behaviour is quite old and daat not sorted for better performance. Index the cursor on the field(s) you use for grouping and set that index active before report running. You can index any cursor or view by INDEX command. When data you use for report are from the SELECT statement, use 'ORDER BY' to sort the result set.
HTH.
>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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.