>I have a report that needs a change. The input data is sorted in order field1, field5, field6. Then on the report the group footer expression is field1, field3, field4. Just wondering how the input data is in one sorted order and the group footer expression is another order. Does the group footer expression sort the data?
>
>Thanks
>
>Brenda

Brenda,

No the grouping does not sort the data. Teh groups wil break whenever the group expression changes. You will find yourself getting multiple groups for the same values if the data is not sorted on the grouping expressions.