-SET &FOOT_TEXT = 'At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, *** soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.'; TABLE FILE CAR SUM COMPUTE FOOT_TEXT/A1200 = '&FOOT_TEXT'; NOPRINT SALES BY COUNTRY BY CAR BY MODEL FOOTING " " "<FOOT_TEXT" ON TABLE SUBFOOT " " "<FOOT_TEXT" ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=PORTRAIT, MARKUP=ON, $ TYPE=REPORT, FONT=ARIAL, SIZE=10, $ TYPE=TABFOOTING, SIZE=8, WRAP=10,COLOR=BLUE , $ TYPE=FOOTING, SIZE=8, WRAP=10,COLOR=RED, $ END -RUN
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 |
-SET &FOOT_TEXT = 'At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, *** soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.'; -SET &FOOT_TEXT = STRREP(&FOOT_TEXT.LENGTH, &FOOT_TEXT.QUOTEDSTRING, 1, ',', 1, '~', 1200, 'A1200'); -SET &TEMPTEXT = 'x,' | PARAG(1200, &FOOT_TEXT.QUOTEDSTRING, ',', 160, 'A160'); EX -LINES * EDAPUT MASTER,TEMPDAT1,C,MEM FILENAME=TEMPDAT1, SUFFIX=FOC SEGNAME=SEG01, SEGTYPE=S1 FIELDNAME=DUMMY, ALIAS=DUMMY, USAGE=A1, ACTUAL=A1, FIELDTYPE=I, $ FIELDNAME=FOOT_TEXT01, ALIAS=FOOT_TEXT01, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT02, ALIAS=FOOT_TEXT02, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT03, ALIAS=FOOT_TEXT03, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT04, ALIAS=FOOT_TEXT04, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT05, ALIAS=FOOT_TEXT05, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT06, ALIAS=FOOT_TEXT06, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT07, ALIAS=FOOT_TEXT07, USAGE=A160, ACTUAL=A160, $ FIELDNAME=FOOT_TEXT08, ALIAS=FOOT_TEXT08, USAGE=A160, ACTUAL=A160, $ EDAPUT* CREATE FILE TEMPDAT1 MODIFY FILE TEMPDAT1 FREEFORM DUMMY FOOT_TEXT01 FOOT_TEXT02 FOOT_TEXT03 FOOT_TEXT04 FOOT_TEXT05 FOOT_TEXT06 FOOT_TEXT07 FOOT_TEXT08 COMPUTE FOOT_TEXT01/A160 = REPLACE(FOOT_TEXT01, '~', ','); COMPUTE FOOT_TEXT02/A160 = REPLACE(FOOT_TEXT02, '~', ','); COMPUTE FOOT_TEXT03/A160 = REPLACE(FOOT_TEXT03, '~', ','); COMPUTE FOOT_TEXT04/A160 = REPLACE(FOOT_TEXT04, '~', ','); COMPUTE FOOT_TEXT05/A160 = REPLACE(FOOT_TEXT05, '~', ','); COMPUTE FOOT_TEXT06/A160 = REPLACE(FOOT_TEXT06, '~', ','); COMPUTE FOOT_TEXT07/A160 = REPLACE(FOOT_TEXT07, '~', ','); COMPUTE FOOT_TEXT08/A160 = REPLACE(FOOT_TEXT08, '~', ','); MATCH DUMMY ON MATCH REJECT ON NOMATCH INCLUDE DATA &TEMPTEXT,$ END -RUN JOIN CLEAR * JOIN DUMMY WITH COUNTRY IN CAR TO DUMMY IN TEMPDAT1 AS J1 DEFINE FILE CAR DUMMY/A1 WITH COUNTRY = 'x'; END TABLE FILE CAR SUM SALES BY COUNTRY BY CAR BY MODEL FOOTING " " "<FOOT_TEXT01" "<FOOT_TEXT02" "<FOOT_TEXT03" "<FOOT_TEXT04" "<FOOT_TEXT05" "<FOOT_TEXT06" "<FOOT_TEXT07" "<FOOT_TEXT08" ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=PORTRAIT, MARKUP=ON, $ TYPE=REPORT, FONT=ARIAL, SIZE=10, $ TYPE=FOOTING, SIZE=8, COLOR=RED, $ END -RUN
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 |