Focal Point
[SOLVED] Variable as Column Header?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9227027276

September 18, 2014, 11:10 AM
ColdWhiteMilk
[SOLVED] Variable as Column Header?
I have two variables:

  
-SET &TODAY = DATECVT(&YYMD, 'I8YYMD', 'YYMD');
-SET &LSTEOM = DATECVT(DATEMOV(DATEADD(&TODAY,'M',-1), 'EOM'), 'YYMD', 'I8YYMD');


Can I do something like this to use the result of the &LSTEOM as the column alias in my report output?

  
TABLE FILE CAR
PRINT
COUNTRY AS '&LSTEOM'

ON TABLE PCHOLD FORMAT HTML
END
-EXIT

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


Production - 7.6.4
Sandbox - 7.6.4
September 18, 2014, 11:21 AM
MichaelBalle
Try it ... it works:

  
Result:
20140831
---------
England
Japan
Italy
W Germany
France




WebFOCUS 7.6, 7.7
Windows, All Output formats
September 18, 2014, 01:09 PM
ColdWhiteMilk
Thank you!

You all saved the day again!


Production - 7.6.4
Sandbox - 7.6.4