By "manual" I'm assuming you mean "I can specify my own group names and ranges" (ie: group by month name even if my data doesn't provide the name).

You can create a formula that will extract the month (and convert it to the name instead of just the number)

MonthName(month({your_date}))

Then create a group on this formula so that it will group all of the records by the month.

You then have the option of using a record selection formula to filter out all the records that you don't want (so you're only left with the next 6 months) or a group selection formula.

Edited by Keikoku - 10 Feb 2011 at 2:56am