>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.
Can you be more specific about what the report looks like ... what the data driving the report looks like ... and exactly how you want these totals to look on the report. There are several ways to come up with totals by month, but I need to know more about what you're trying to achieve to give you the best solution.
