I'm building a report that lists records that are BETWEEN two date parameters. I want to be able to group these by an additional range. Eventually I'd like to make this group dynamic but for now I just want to look at a way to accomplish the following example.
The dates 1/1/2009 and 12/31/2009 are entered. Out of those records I would like to include all records in this date range on the report. However, I want to separate the records by another date range of 4/1/2009 and 8/31/2009. So on the report I would want to list three groups with details, totals, etc.
Group 1
Records for date range 1/1/2009 - 3/31/2009
Group 2
Records for date range 4/1/2009 - 8/31/2009
Group 3
Records for date range 9/1/2009 - 12/31/2009