Focal Point
[SOLVED] Additional column text

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

February 20, 2011, 05:11 AM
ChristianP
[SOLVED] Additional column text
Hello,
i am building a report using across, and i want to add additional text to the across columns-header in the html output. The actual column-header in the output is for some gyus in my department to cryptic.

Christian

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


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
February 20, 2011, 08:54 AM
FrankDutch
you can create a decode in your define

for example

DEFINE FILE XYZ
NEWDESCR/A15=DECODE CRYPTIC('ABC' 'the alphabet' '123' 'the numbers' '3AB' 'other code' ELSE 'no idea');
END
TABLE FILE XYZ
SUM FIELD1
BY FIELD2 
ACROSS CRYPTIC NOPRINT (to keep the sequence)
ACROSS NEWDESCR AS ''
END


good luck




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 21, 2011, 03:58 AM
ChristianP
Hello Frank,

works perfect!!!! Exactly what i needed!!! How can i edit the header from my topic to show that may problem is solved??

Christian


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
February 21, 2011, 07:32 AM
FrankDutch
if you click the "edit" button of the initianal question you can change the query




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7