I see - I didn't realize that this was specifically linked to SFReports. Strange to have a limitation like that!

>Barbara,
>
>I know how to do this in SQL, what I am referring to is the report wizard end users will be using in SFReports. Sorry I wasn't clear in my message. On the sort page they have an up/down button for sort order, but if you choose a field for grouping the report automatically sorts, but you have no control of up/down. It isn't a big deal, but ...
>
>Thanks,
>Jack
>
>>Jack, this shouldn't be a problem. Would you please post the code in the SQL so we can look at the syntax you're using?
>>
>>Thanks,
>>Barbara
>>
>>>I can't sort my report descending if I group by a field, while I can if the fields is only a sort field. Is this a limitation or is there a workaround. Any ideas?
>>>
>>>Jack