Formula to sort record regardless of a group

[olushow]

Is there a way to sort a report, even thought there is an existing group. I was able to sort each record within each group, but it seems the client want the records sorted regardless of the existing grouping..

For example.

Records are grouped into the following East Coast, West Coast, Southern Coast.....you catch my drift..

and within each region I currently have a sort that lists the oldest open case in terms of how long a day has been opened. What my client now wants is to sort oldest record regardless of the grouping. My understanding is that the grouping takes precedence over the sorting. Is there a quick and dirty way to work around this?

 

[lbass]

Sounds like you need to get rid of the region group then. You can do a group sort by inserting a summary on the date field, but this would just sort the regions or the cases within the regions if you have an inner group on case.

-LB