It's not quite as simple as that. There's a lot of felds that need to move depending on what the order is. I've decided it's easier to just go with three reports that cover all the various combinations.
Thanks,
Michelle
>Cathy and Michelle --
>
>Use the AS clause for the various grouping names rather than their field names, such as Group1, Group2, Group3.
>
>Design the report using the Group1..3 names.
>
>In your preprocessing of SQL for each invocation, assign the desired grouping fields to the Group1..3 names:
>
>*1 invocation
>SELECT State AS Group1, SalesRange AS Group2, ServiceRange AS Group3...
>
>*2 invocation
>SELECT ServiceRange AS Group1, State AS Group2, SalesRange AS Group3...
>
>etc.
>
>
>and modify as needed.
>
>Jay