I'm not having any success to get my variable column title to work. Basically, it based on if NEWDATE is LT 09/30/2010 make it 'RevPH' else it should be 'RevCr'. It's always displaying RevCr for any date. I suspect it has something to do with my date. Thanks!
Here's DM code:
DEFINE FILE SQLOUT -*QDATE/MDYY=QTDATE; NEWDATE/MDYY=HDATE(QTDATE, 'MDYY'); END -SET &RPT = NEWDATE; -SET &COL3HDR = IF &RPT LT '09/30/2010' THEN 'RevPH' ELSE 'RevCr'; -RUNThis message has been edited. Last edited by: Kerry,
WebFocus 7.7.02 WinXP
DEFINE FILE SQLOUT NEWDATE/MDYY=HDATE(QTDATE, 'MDYY'); XDATE/YYMD = HDATE(QTDATE, 'YYMD'); END TABLE FILE SQLOUT SUM XDATE IF RECORDLIMIT EQ 1 ON TABLE SAVE END -RUN -READ SAVE &XDATE.A10. -* -SET &RPT = NEWDATE; -SET &COL3HDR = IF '&XDATE.EVAL' LT '2010/09/30' THEN 'RevPH' ELSE 'RevCr';
Won't comment on the hard-coding...
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
How many values can a variable hold at one time?
The answer is an integer less than 2 but greater than 0.
You will not.
If you want Dynamic column headings then you need a compound report. or
you need to use subhead with indexed / mutiple variables based on a define/compute and a BY.
|Powered by Social Strata|