Hi all,

I have the following requirement.

I need to display the data in this order


2012 2011 q1-2012 q1-2011
------------------------------------------
Income
Expense

i will not pass any parameter but the report has to calculate the current year and current quarter values. Is it possible to do this in webfocus?

Thanks,
Guru
webfocus 7.7.03

Yes.

Here's something to start with:

-SET &YEAR=EDIT(&DATEYYQ,'9999');
-SET &QTR=EDIT(&DATEYYQ,'$$$$$99');

DEFINE FILE CAR
 SEQ/I2 WITH MODEL = SEQ+1;
 TODAY/YYMD='&YYMD';
 DATE/YYMD=TODAY + 91 * (SEQ-1);
 YEAR/YY=DATE; 
 Y/I4=YEAR;
 QTR/Q=DATE;  
 Q/I6=QTR;
END

TABLE FILE CAR
HEADING
" TODAY: &YYMD  YEAR: &YEAR   QTR:  &QTR"
PRINT DATE YEAR  Y QTR   Q  
BY SEQ 
WHERE QTR EQ '&QTR';
END