I need to show totals in a grouping of a report. This SQL just simply gets the total count meeting the criteria.

SELECT ;
	COUNT(*) AS DOSCnt ;
 FROM EligAct ;
	WHERE BETWEEN(EligAct.DOSBegin,THISFORM.DOSBegin,THISFORM.DOSEnd) ;
	INTO CURSOR ReportCursorSummary

I need to change it, or create another one, that will show a breakdown by month for the same criteria.

Jan: 12
Feb: 100
Mar: 325

Or...

Jan: 12     Feb: 100     Mar: 325

I can do the SQL, but what I'm really wondering is if this approach is the best way. If not using MONTH, etc in the SQL fields, what would work well? I need to do it in a grouping due to some shapes in the report that only display correctly if they just come under the last grouping. I need the summary totals to be in a grouping or they will look odd with lots of white space possible between them and the last detail line.