I have a report which groups by "proposal status." So: "in development," "submitted," "accepted," "rejected," etc...

What I need to do is keep the grouping by proposal status but sort differently within each section depending on what the status is. For example, for the "accepted" section I want to sort by "date accepted" but for the "development" section I want to sort by "client name." Is there any way to do this? I thought of using a formula to sort by but since "date accepted" is a date field and "client name" is a string, it doesn't seem to work.

Worked like a charm! Much thanks DBlank.