SET ACROSSTITLE = SIDE TABLE FILE CAR SUM DEALER_COST BY MODEL AS '' BY BODYTYPE AS '' ACROSS COUNTRY NOPRINT ACROSS CAR NOPRINT ACROSS COUNTRY AS ' ' ACROSS CAR AS 'bodytype' -*ON TABLE PCHOLD FORMAT XLSX ON TABLE NOTOTAL ON TABLE SET STYLE * $ TYPE=REPORT, FONT='VERDANA', SIZE=9, $ ENDSTYLE ENDThis message has been edited. Last edited by: <Kathryn Henning>,
SET ACROSSTITLE = SIDE TABLE FILE CAR SUM DEALER_COST BY MODEL AS 'Model' BY BODYTYPE AS 'Body Type' ACROSS COUNTRY NOPRINT ACROSS CAR NOPRINT ACROSS COUNTRY AS 'Country:' ACROSS CAR AS 'Car:' -*ON TABLE PCHOLD FORMAT XLSX ON TABLE NOTOTAL ON TABLE SET STYLE * $ TYPE=REPORT, FONT='VERDANA', SIZE=9, $ ENDSTYLE END
TABLE FILE CAR BY COUNTRY BY CAR ON TABLE HOLD AS TITLES END -RUN -SET &Title1 = ' <+0>'; -SET &Title2 = 'Model<+0>Body Type'; -REPEAT :Loop &LINES TIMES; -READFILE TITLES -SET &Title1 = &Title1 || (' <+0>'|&COUNTRY); -SET &Title2 = &Title2 || (' <+0>'|&CAR); -:Loop TABLE FILE CAR SUM DEALER_COST AS '' BY MODEL AS '' BY BODYTYPE AS '' ACROSS COUNTRY NOPRINT ACROSS CAR NOPRINT HEADING "&Title1.EVAL" "&Title2.EVAL" ON TABLE PCHOLD FORMAT XLSX ON TABLE NOTOTAL ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * include=endeflt,$ TYPE=REPORT, FONT='VERDANA', SIZE=9, HEADALIGN=BODY, WRAP=OFF, $ TYPE=HEADING, SIZE=9, JUSTIFY=LEFT, $ TYPE=REPORT, COLUMN=DEALER_COST, WIDTH=.8, WRAP=.8, $ ENDSTYLE END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:TABLE FILE CAR
BY COUNTRY
BY CAR
ON TABLE HOLD AS TITLES
END
-RUN
-SET &Title1 = ' <+0>';
-SET &Title2 = 'Model<+0>Body Type';
-REPEAT :Loop &LINES TIMES;
-READFILE TITLES
-SET &Title1 = &Title1 || (' <+0>'|&COUNTRY);
-SET &Title2 = &Title2 || (' <+0>'|&CAR);
-:Loop
TABLE FILE CAR
SUM DEALER_COST AS ''
BY MODEL AS ''
BY BODYTYPE AS ''
ACROSS COUNTRY NOPRINT
ACROSS CAR NOPRINT
HEADING
"&Title1.EVAL"
"&Title2.EVAL"
ON TABLE PCHOLD FORMAT XLSX
ON TABLE NOTOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
include=endeflt,$
TYPE=REPORT, FONT='VERDANA', SIZE=9, HEADALIGN=BODY, WRAP=OFF, $
TYPE=HEADING, SIZE=9, JUSTIFY=LEFT, $
TYPE=REPORT, COLUMN=DEALER_COST, WIDTH=.8, WRAP=.8, $
ENDSTYLE
END
quote:It helped a lot and I was able to solve the use case.
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |