Hello,

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';
-RUN 

This message has been edited. Last edited by: Kerry,

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

quote:

I'm not having any success to get my variable column title to work

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.