April 26, 2005, 10:51 AM
HåkanMultiple rows for ACROSSTITLE
Is it possible to have the ACROSSTITLE to span multiple rows? I want the name of the Day on one row and the actual date on line 2. I've managed to do it for HTML output with the following code:
D_DAY_NAME2/A23 = IF '&SEL_OUTPUT' EQ 'HTML' THEN D_DAY_NAME | '<br>' | D_DATE ELSE D_DAY_NAME;
(D_DAY_NAME contains the Day Name and D_DATE the actual date).
My question is if it is possible to do it for PDF and EXCEL?
We're on WF 5.2.7 on IBM iSeries.
Tia
April 26, 2005, 09:43 PM
k.laneTia,
One way you can accomplish this is through using multiple ACROSS fields. I just mocked this one up.
TABLE FILE <tablename>
SUM COMPUTE DOL_AMT/D20.2 = 999.99 ;
COMPUTE ID_DATE/I8YYMD = RUN_DATE; NOPRINT
COMPUTE D_DAY_NAME/A12 = DOWKL(ID_DATE,D_DAY_NAME);
BY D_DATE
BY ENTITY_TYPE_CODE
WHERE RECORDLIMIT EQ 10
ON TABLE HOLD AS TEST
END
TABLE FILE TEST
SUM DOL_AMT AS ''
BY ENTITY_TYPE AS ''
ACROSS D_DATE NOPRINT
ACROSS D_DAY_NAME AS 'Date'
ACROSS D_DATE AS ''
ON TABLE SET PAGE-NUM OFF
END
By using this method, you will see two lines for the acrosstitles.
I use this method regularly and it does work for both PDF and EXL2K.
I hope this helps.
K
April 27, 2005, 11:33 AM
HåkanThanks,
why that didn't come into my mind. I must have left at least part of my brain at home...