One way to handle report grouping on different fields (depending on user-picked sort order) is to have a GROUPBY field in the SQL which varies depending on the sort order. I use a variable for the actual field name(s) which is called with a macro in the SQL. Then the report is always grouped on the GROUPBY field.
HTH
Barbara
>Eric,
>
>The way we usually do it is to have the users make his selections (order,filtered info,etc) and then do a SQL select into a cursor (or set a filter which is slower) and then lauch the report.
>
>Once catch: if you let the user select the report order you have to make sure that any subgrouping your report does will still be functional.
>
>HTH
>
>Pascal