It's simple to create SQL either way (one record based or multiple records). I think you may try SQL solution. You can also use group by month in the Report itself with totals.

>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.