SET COMPOUND = OPEN -INCLUDE RECAP_PAGE.FEX -LOOP_START -SET &COMPOUNDCODE = IF &DONE EQ 'TRUE' THEN 'SET COMPOUND = CLOSE' ELSE ''; &COMPOUNDCODE.EVAL -INCLUDE STORE_PAGE.FEX -IF &DONE EQ 'TRUE' THEN CONTINUE ELSE GOTO LOOP_START -* done :-)
quote:I think I can not use a Composer document ( coordinated report ) because then I can not have recap.
-* Default Mode: ResourceLayout SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT PDF UNITS=IN, $ SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4, SHOW_GLOBALFILTER=OFF, $ PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, $ COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.497 1.351), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart1', TEXT='chart1', TOC-LEVEL=2, POSITION=(3.415 1.355), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(5.519 1.351), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart2', TEXT='chart2', TOC-LEVEL=2, POSITION=(8.444 1.355), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.497 4.688), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart3', TEXT='chart3', TOC-LEVEL=2, POSITION=(3.415 4.685), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(5.524 4.688), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart4', TEXT='chart4', TOC-LEVEL=2, POSITION=(8.444 4.685), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, $ COMPONENT='report5', TEXT='report5', TOC-LEVEL=2, POSITION=(0.497 1.351), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart5', TEXT='chart5', TOC-LEVEL=2, POSITION=(3.415 1.355), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report6', TEXT='report6', TOC-LEVEL=2, POSITION=(5.519 1.351), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart6', TEXT='chart6', TOC-LEVEL=2, POSITION=(8.444 1.355), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report7', TEXT='report7', TOC-LEVEL=2, POSITION=(0.497 4.688), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart7', TEXT='chart7', TOC-LEVEL=2, POSITION=(3.415 4.685), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ COMPONENT='report8', TEXT='report8', TOC-LEVEL=2, POSITION=(5.524 4.688), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart8', TEXT='chart8', TOC-LEVEL=2, POSITION=(8.444 4.685), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ END -SET &Region = 'Northeast'; SET COMPONENT='report1' -*component_type report -INCLUDE region_rep.fex SET COMPONENT='chart1' -*component_type chart -INCLUDE region_chart.fex -SET &Region = 'Southeast'; SET COMPONENT='report2' -*component_type report -INCLUDE region_rep.fex SET COMPONENT='chart2' -*component_type chart -INCLUDE region_chart.fex -SET &Region = 'West'; SET COMPONENT='report3' -*component_type report -INCLUDE region_rep.fex SET COMPONENT='chart3' -*component_type chart -INCLUDE region_chart.fex -SET &Region = 'Midwest'; SET COMPONENT='report4' -*component_type report -INCLUDE region_rep.fex SET COMPONENT='chart4' -*component_type chart -INCLUDE region_chart.fex -SET &Region = 'Northeast'; SET COMPONENT='report5' -*component_type report -INCLUDE city_rep.fex SET COMPONENT='chart5' -*component_type chart -INCLUDE city_chart.fex -SET &Region = 'Southeast'; SET COMPONENT='report6' -*component_type report -INCLUDE city_rep.fex SET COMPONENT='chart6' -*component_type chart -INCLUDE city_chart.fex -SET &Region = 'West'; SET COMPONENT='report7' -*component_type report -INCLUDE city_rep.fex SET COMPONENT='chart7' -*component_type chart -INCLUDE city_chart.fex -SET &Region = 'Midwest'; SET COMPONENT='report8' -*component_type report -INCLUDE city_rep.fex SET COMPONENT='chart8' -*component_type chart -INCLUDE city_chart.fex COMPOUND 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 |
SET EMPTYREPORT = ON TABLE FILE GGSALES BY CITY ON TABLE SET HOLDLIST PRINTONLY ON TABLE SAVE AS CITYDATA END -RUN FILEDEF PDF_PART1 DISK PDF_PART1.fex FILEDEF PDF_PART2 DISK PDF_PART2.fex -RUN -WRITE PDF_PART1 -DEFAULTH &|Region = 'FOC_NONE' -WRITE PDF_PART1 SET HTMLARCHIVE=ON -WRITE PDF_PART1 *-HOLD_SOURCE -WRITE PDF_PART1 COMPOUND LAYOUT PCHOLD FORMAT PDF -WRITE PDF_PART1 UNITS=IN, $ -WRITE PDF_PART1 SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=A4, SHOW_GLOBALFILTER=OFF, $ -* First Page - Nationwide Data -WRITE PDF_PART1 pagelayout=1, name='Layout page 1', $ -WRITE PDF_PART1 object=string, name='text1', text='Nationwide report - Split by Region', position=(0.5 0.3), dimension=(5.0 0.3), $ -WRITE PDF_PART1 COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.5 0.5), DIMENSION=(2.5 3.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart1', TEXT='chart1', TOC-LEVEL=2, POSITION=(3.5 0.5), DIMENSION=(2.5 2.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(6.0 0.5), DIMENSION=(2.5 3.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart2', TEXT='chart2', TOC-LEVEL=2, POSITION=(9.0 0.5), DIMENSION=(2.5 2.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.5 4.5), DIMENSION=(2.5 3.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart3', TEXT='chart3', TOC-LEVEL=2, POSITION=(3.5 4.5), DIMENSION=(2.5 2.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(6.0 4.5), DIMENSION=(2.5 3.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart4', TEXT='chart4', TOC-LEVEL=2, POSITION=(9.0 4.5), DIMENSION=(2.5 2.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Region = 'Northeast'; -WRITE PDF_PART2 SET COMPONENT='report1' -WRITE PDF_PART2 -INCLUDE region_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart1' -WRITE PDF_PART2 -INCLUDE region_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Region = 'Southeast'; -WRITE PDF_PART2 SET COMPONENT='report2' -WRITE PDF_PART2 -INCLUDE region_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart2' -WRITE PDF_PART2 -INCLUDE region_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Region = 'West'; -WRITE PDF_PART2 SET COMPONENT='report3' -WRITE PDF_PART2 -INCLUDE region_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart3' -WRITE PDF_PART2 -INCLUDE region_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Region = 'Midwest'; -WRITE PDF_PART2 SET COMPONENT='report4' -WRITE PDF_PART2 -INCLUDE region_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart4' -WRITE PDF_PART2 -INCLUDE region_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -SET &Cnt = 2; -READ CITYDATA NOCLOSE &City.A20. -REPEAT :Loop WHILE &IORETURN EQ 0; -SET &City = TRUNCATE(&City); -WRITE PDF_PART1 pagelayout=&Cnt.EVAL, name='Layout page &Cnt.EVAL', $ -WRITE PDF_PART1 object=string, name='text1_&Cnt.EVAL', text='Product Report for City: &City.EVAL', position=(0.5 0.3), dimension=(5.0 0.3), $ -WRITE PDF_PART1 COMPONENT='report1_&Cnt.EVAL', TEXT='report1_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(0.5 0.5), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart1_&Cnt.EVAL', TEXT='chart1_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(3.5 0.5), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report2_&Cnt.EVAL', TEXT='report2_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(6.0 0.5), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart2_&Cnt.EVAL', TEXT='chart2_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(9.0 0.5), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report3_&Cnt.EVAL', TEXT='report3_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(0.5 2.25), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart3_&Cnt.EVAL', TEXT='chart3_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(3.5 2.25), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report4_&Cnt.EVAL', TEXT='report4_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(6.0 2.25), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart4_&Cnt.EVAL', TEXT='chart4_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(9.0 2.25), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report5_&Cnt.EVAL', TEXT='report5_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(0.5 4.0), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart5_&Cnt.EVAL', TEXT='chart5_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(3.5 4.0), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report6_&Cnt.EVAL', TEXT='report6_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(6.0 4.0), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart6_&Cnt.EVAL', TEXT='chart6_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(9.0 4.0), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report7_&Cnt.EVAL', TEXT='report7_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(0.5 5.75), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart7_&Cnt.EVAL', TEXT='chart7_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(3.5 5.75), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 COMPONENT='report8_&Cnt.EVAL', TEXT='report8_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(6.0 5.75), DIMENSION=(2.5 1.5), BYTOC=0, $ -WRITE PDF_PART1 COMPONENT='chart8_&Cnt.EVAL', TEXT='chart8_&Cnt.EVAL', TOC-LEVEL=2, POSITION=(9.0 5.75), DIMENSION=(2.5 1.5), COMPONENT-TYPE=GRAPH, $ -WRITE PDF_PART1 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|City = '&City.EVAL'; -WRITE PDF_PART2 -SET &|Product = 'Biscotti'; -WRITE PDF_PART2 SET COMPONENT='report1_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart1_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = 'Capuccino'; -WRITE PDF_PART2 SET COMPONENT='report2_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart2_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = '''Coffee Grinder'' OR ''Coffee Pot'''; -WRITE PDF_PART2 SET COMPONENT='report3_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart3_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = '''Croissant'' OR ''Scone'''; -WRITE PDF_PART2 SET COMPONENT='report4_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart4_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = 'Espresso'; -WRITE PDF_PART2 SET COMPONENT='report5_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart5_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = 'Latte'; -WRITE PDF_PART2 SET COMPONENT='report6_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart6_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = 'Mug'; -WRITE PDF_PART2 SET COMPONENT='report7_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart7_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -WRITE PDF_PART2 -SET &|Product = 'Thermos'; -WRITE PDF_PART2 SET COMPONENT='report8_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_rep.fex -WRITE PDF_PART2 SET COMPONENT='chart8_&Cnt.EVAL' -WRITE PDF_PART2 -INCLUDE city_chart.fex -WRITE PDF_PART2 -* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -READ CITYDATA NOCLOSE &City.A20. -SET &Cnt = &Cnt + 1; -:Loop -WRITE PDF_PART1 END -WRITE PDF_PART2 COMPOUND END CMD COPY PDF_PART1.fex+PDF_PART2.FEX PDF_CONTROL.FEX -RUN -*CMD TYPE PDF_CONTROL.FEX EX PDF_CONTROL
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 |
-LOOP_START1 -SET &POSX = magic_calculation_here; -SET &POSX2 = magic_calculation_here; -SET &POSY = magic_calculation_here; COMPONENT='report&COUNTER', TEXT='report&COUNTER', TOC-LEVEL=2, POSITION=(&POSX &POSY), DIMENSION=(2.400 1.456), BYTOC=0, $ COMPONENT='chart&COUNTER', TEXT='chart&COUNTER', TOC-LEVEL=2, POSITION=(&POSX2 &POSY), DIMENSION=(2.000 1.456), COMPONENT-TYPE=GRAPH, $ -IF DONE EQ 'YES' THEN CONTINUE ELSE GOTO LOOP_START1; -LOOP_START2 -SET &Region = '&LOOPVALUE'; SET COMPONENT='report&COUNTER' -*component_type report -INCLUDE city_rep.fex SET COMPONENT='chart&COUNTER' -*component_type chart -INCLUDE city_chart.fex -IF DONE EQ 'YES' THEN CONTINUE ELSE GOTO LOOP_START2;
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:what is the use of BYTOC=0 in compound PDF report?
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 |
OBJECT=BOOKMARKS, $
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 |