Annual Report

[pvuppa1]

Can anyone help me with creating an annual report.
I have now quarterly reports based on some set of dates it gives me number of records affected for some where clause.
DEFINE FILE MYFILE
BEGinDATE/YYMD DFC 20 YRT 00='&Begin_date';
ENDDATE/YYMD DFC 20 YRT 00='&End_date';
KOUNT1/D12=IF
(SOMEFIELD1 GE BEGINDATE) AND
(SOMEFIELD1 LE ENDDATE) THEN 1
ELSE 0;
KOUNT2/D12=IF SOMEFIELD2 GE BEGINDATE
AND SOMEFIELD2 LE ENDDATE
AND SOMETHINGELSE EQ 'somevalue' THEN 1
ELSE 0;
END
TABLE FILE MYFILE
SUM
KOUNT1 AS 'DISPLAY1' OVER
KOUNT2 AS 'DISPLAY2'
END.
The generated report is
display1 (value1)
display2 (value2)
how do I create an annual report with all same counts but for 4 different quarters. Any ideas would be greatly appreciated.
I am looking forward to create a report as follows
Qtr1 Qtr2 Qtr3 Qtr4
display1 value11 value12 value13 value14
display2 value21 value22 value24 value24

Thanks a bunch.
-P

 

[kiddpete]

Define a field for quarter (1-4) and add;

ACROSS quarter

to your report.

 

[pvuppa1]

Thank you! It works !
-P