Focal Point
[SOLVED] Smart usage of OVERFLOW-POSITION and OVERFLOW-DIMENSION

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

January 11, 2016, 07:10 AM
Ricardo Augusto
[SOLVED] Smart usage of OVERFLOW-POSITION and OVERFLOW-DIMENSION
Hi,

Can anyone share a smart usage of
OVERFLOW-POSITION and OVERFLOW-DIMENSION from a COMPOUND PDF report?

I have a recursive report that creates a PDF compound. It creates reports A, B, C, D, E. I need to configure these variables to fit 2 reports per page.

Page 1 ( Reports A, B )
Page 2 ( Reports C, D )
Page 3 ( Reports E, F )

Is there a way to set them to be dynamic?


Any hint?

Thanks

This message has been edited. Last edited by: Ricardo Augusto,


WebFOCUS 8.1.05 / APP Studio
January 12, 2016, 04:53 AM
Ricardo Augusto
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/ibisamp/exemplos/Procedure1.fex Created by WebFOCUS AppStudio



SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF AS TEST
UNITS=PTS, $
SECTION=section1, LAYOUT=ON, METADATA='5^5^5^5^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=ALL, $
COMPONENT=HEADER, TYPE=REPORT, POSITION=(7 7), DIMENSION=(* *), $
OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

OBJECT=STRING, NAME='Prog', TEXT='Prog: TEST_COMPOUND_PDF', POSITION=(+535 800), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

PAGELAYOUT=1, NAME='TEST_COMPOUND_PDF', text='TEST_COMPOUND_PDF', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $
-*OBJECT=IMAGE, NAME='image1', IMAGE=ford_logo.jpg, ALT='', POSITION=(7 7), DIMENSION=(88 32),  $
COMPONENT='RPT1', TEXT='RPT1', POSITION=(10 40), DIMENSION=(150 *), $
COMPONENT='RPT2', TEXT='RPT2', POSITION=(10 330), DIMENSION=(* *),OVERFLOW-POSITION=(10 40), OVERFLOW-DIMENSION=(* *), $
COMPONENT='RPT3', TEXT='RPT3', POSITION=(1 480), DIMENSION=(* *), OVERFLOW-POSITION=(10 40), OVERFLOW-DIMENSION=(* *), $
COMPONENT='RPT4', TEXT='RPT4', POSITION=(1 880), DIMENSION=(* *),OVERFLOW-POSITION=(10 40), OVERFLOW-DIMENSION=(* *), $



-RUN


SET COMPONENT=HEADER
TABLE FILE CAR
HEADING
"TEST COMPOUND REPORT"
"Period: &YYMD"
"Company XPZ"
"&DATEDwMtrYY &TOD"
BY COUNTRY NOPRINT
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=ford_logo.jpg, SIZE=(1.000000 0.300000),  $
TYPE=HEADING, FONT="FORD CE BLACK", $
TYPE=HEADING, POSITION=1.05, $
TYPE=HEADING, LINE=1, SIZE=12, STYLE='BOLD', POSITION=1.05, $
TYPE=HEADING, LINE=2, SIZE=8,  STYLE='BOLD', JUSTIFY=RIGHT, $
TYPE=HEADING, LINE=3, SIZE=8, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=4, SIZE=6, JUSTIFY=RIGHT, $

END

-RUN

SET COMPONENT = RPT1

TABLE FILE CAR
SUM SALES
BY MODEL
ACROSS COUNTRY
HEADING 
"REPORT 1"
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,  ORIENTATION=PORTRAIT, SQUEEZE=ON, $
     INCLUDE = endeflt,
$

TYPE=REPORT, GRID=OFF, SIZE=6, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=7,  $

TYPE=HEADING,
     LINE=1,
	 SIZE=7,
     JUSTIFY=LEFT,
$

ENDSTYLE
END



-* REPORT 2

SET COMPONENT = RPT2

TABLE FILE CAR
SUM SALES

BY COUNTRY
HEADING 
"REPORT 2"
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,  ORIENTATION=PORTRAIT, SQUEEZE=ON, $
     INCLUDE = endeflt,
$

TYPE=REPORT, GRID=OFF, SIZE=6, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=7,  $

TYPE=HEADING,
     LINE=1,
	 SIZE=7,
     JUSTIFY=LEFT,
$

ENDSTYLE
END

-RUN




SET COMPONENT = RPT3

TABLE FILE CAR
SUM SALES

BY MODEL
HEADING 
"REPORT 3"
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,  ORIENTATION=PORTRAIT, SQUEEZE=ON, $
     INCLUDE = endeflt,
$

TYPE=REPORT, GRID=OFF, SIZE=6, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=7,  $

TYPE=HEADING,
     LINE=1,
	 SIZE=7,
     JUSTIFY=LEFT,
$

ENDSTYLE
END

-RUN


SET COMPONENT = RPT4

TABLE FILE CAR
SUM SALES

BY BODYTYPE
HEADING 
"REPORT 4"
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,  ORIENTATION=PORTRAIT, SQUEEZE=ON, $
     INCLUDE = endeflt,
$

TYPE=REPORT, GRID=OFF, SIZE=6, $
TYPE=TITLE, SIZE= 7, $
TYPE=DATA, SIZE=6,BACKCOLOR=( 'WHITE' RGB(235 235 240) ), $
TYPE=ACROSSVALUE, SIZE=7,  $

TYPE=HEADING,
     LINE=1,
	 SIZE=7,
     JUSTIFY=LEFT,
$

ENDSTYLE
END






  



WebFOCUS 8.1.05 / APP Studio
January 12, 2016, 06:09 PM
StuBouyer
Ricardo,

OVERFLOW-POSITION and OVERFLOW-DIMENSION only come into play when the report component doesn't fit on the page that it set for. These values then control where on the overflow page to put the rest of the report.

If I am reading your question correctly you want to resize the reports on each page. Assuming that Report A and Report B (and C & D, E & F) together will always fit on a single page then you can do something like this:

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF AS TEST
UNITS=PTS, $
SECTION=section1, LAYOUT=ON, METADATA='5^5^5^5^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=ALL, $
COMPONENT=HEADER, TYPE=REPORT, POSITION=(7 7), DIMENSION=(* *), $
OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

OBJECT=STRING, NAME='Prog', TEXT='Prog: TEST_COMPOUND_PDF', POSITION=(+535 800), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

PAGELAYOUT=1, NAME='TEST_COMPOUND_PDF', text='TEST_COMPOUND_PDF', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $
-*OBJECT=IMAGE, NAME='image1', IMAGE=ford_logo.jpg, ALT='', POSITION=(7 7), DIMENSION=(88 32),  $
COMPONENT='RPT1', TEXT='RPT1', POSITION=(10 40), DIMENSION=(150 *), $
COMPONENT='RPT2', TEXT='RPT2', POSITION=(+0.00 +0.00), DIMENSION=(* *),RELATIVE-TO='RPT1', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, $
PAGELAYOUT=2, NAME='TEST_COMPOUND_PDF', text='TEST_COMPOUND_PDF', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $
COMPONENT='RPT3', TEXT='RPT3', POSITION=(10 40), DIMENSION=(* *), $
COMPONENT='RPT4', TEXT='RPT4', POSITION=(+0.00 +0.00), DIMENSION=(* *),RELATIVE-TO='RPT3', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $


Hope that helps

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
January 13, 2016, 04:30 AM
Ricardo Augusto
Good Morning.

Thanks a lot Stu. It works like a charm!


My final code:

 
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF AS ADVR_0023
UNITS=PTS, $
SECTION=section1, LAYOUT=ON, METADATA='5^5^5^5^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=A3, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=ALL, $
COMPONENT=HEADER, TYPE=REPORT, POSITION=(7 7), DIMENSION=(* *), $
OBJECT=STRING, NAME='Page', TEXT='Page <ibi-page-number/> of <ibi-total-pages/>', POSITION=(+545 50), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

OBJECT=STRING, NAME='Prog', TEXT='Prog: advr0023', POSITION=(+535 800), MARKUP=OFF,
        WRAP=ON, DIMENSION=(6.0 0.2) FONT='FORD CE BLACK', COLOR=RGB(128 128 128), STYLE=BOLD, SIZE=6, $

PAGELAYOUT=1, NAME='ADVR_0023', text='ADVR_0023', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $
-*OBJECT=IMAGE, NAME='image1', IMAGE=ford_logo.jpg, ALT='', POSITION=(7 7), DIMENSION=(88 32),  $
COMPONENT='CARS', TEXT='CARS', POSITION=(1 50), DIMENSION=(150 *), $
COMPONENT='LIGHTS', TEXT='LIGHTS', POSITION=(+1.00 +35.00), DIMENSION=(* *),RELATIVE-TO='CARS', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $
COMPONENT='BUS', TEXT='BUS', POSITION=(+1.00 +35.00), DIMENSION=(* *),RELATIVE-TO='LIGHTS', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $

PAGELAYOUT=2, NAME='ADVR_0023', text='ADVR_0023', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $

COMPONENT='TRUCKS', TEXT='TRUCKS', POSITION=(1 50), DIMENSION=(* *), $
COMPONENT='MEZCLA', TEXT='MEZCLA', POSITION=(+1.00 +25.00), DIMENSION=(* *), RELATIVE-TO='TRUCKS', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $
COMPONENT='FORD CARS', TEXT='FORD CARS', POSITION=(+1.00 +25.00), DIMENSION=(* *), RELATIVE-TO='MEZCLA', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $
COMPONENT='FORD LIGHTS', TEXT='FORD LIGHTS', POSITION=(+1.00 +25.00), DIMENSION=(* *), RELATIVE-TO='FORD CARS', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $
COMPONENT='FORD TRUCKS', TEXT='FORD TRUCKS',POSITION=(+1.00 +25.00), DIMENSION=(* *), RELATIVE-TO='FORD LIGHTS', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT,  $

PAGELAYOUT=3, NAME='ADVR_0023', text='ADVR_0023', TOC-LEVEL=1, TOPMARGIN=1, ORIENTATION=LANDSCAPE, $
COMPONENT='FORD MEZCLA', TEXT='FORD MEZCLA', POSITION=(1 50), DIMENSION=(* *), $

 



WebFOCUS 8.1.05 / APP Studio