Sorting Groups in a Report

We have a report that shows any due dates for some of our projects. Each sheet is it's own project and the sheet name is the project name. In the report, we utilize grouping by Sheet Name because we like that we can see the project name and the tasks that are coming up underneath it. However, it sorts these groups alphabetically which is kind of awkward because then we have projects near the bottom of the report that have a sooner due date than other projects. So we want a way to sort by due date but have it grouped by sheet name in a way that shows the closest due date first. Any idea on how to achieve what we want?

Answers