Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] variable column titles
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] variable column titles
 Login/Join
 
Platinum Member
posted
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,


WebFocus 7.7.02 WinXP
 
Posts: 236 | Registered: May 12, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
  
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...


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1946 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
<JG>
posted
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.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] variable column titles

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.