Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Manual Page Break

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Manual Page Break
 Login/Join
 
Member
posted
I have a compound pdf report. Depending on the selections made by the user, I may need to generate 1 or 2 pages in the middle of the report. Thanks to previous help on this formum I'm able to generate the correct text on the report but i may end up with two pages that only have 1/2 page worth of text. What i would like to do is insert my own PAGE-BREAK. Seems simple enough but I have not been able to figure it out. Any ides or suggestions or a straight answer that it can't be done would be most helpful. Here is a sample of my code: This fex gets included from another.

I have stripped the text and replaced with 'XX's to hopefully make it a littler easier to read.

 -* File Page2and3.fex

-SET &STARTTOP=0.854;

SET DMPRECISION=3
-RUN

JOIN
 G108ASSUMPTIONS.G108ASSUMPTIONS.G108ASSUMPTIONSID IN g108assumptions TO MULTIPLE
 G108OPTIONS.G108OPTIONS.G108ASSUMPTIONSID IN g108options AS J0
 END
DEFINE FILE G108ASSUMPTIONS ADD
BP1/A2=DECODE G108OPTIONS.G108OPTIONS.BENEFITPERIOD( '3 month' 1 '6 month' 1 '12 month' 2 '24 month' 3 '5 year/5 year' 3 'to age 65' 3);
BP2/A2=DECODE G108OPTIONS.G108OPTIONS.BENEFITPERIOD( '3 month' 1 '6 month' 2 '12 month' 2 '24 month' 2 '5 year/5 year' 2 'to age 65' 2);
BP3/A2=DECODE G108OPTIONS.G108OPTIONS.BENEFITPERIOD( '3 month' 1 '6 month' 1 '12 month' 1 '24 month' 2 '5 year/5 year' 2 'to age 65' 2);
BP4/A2=DECODE G108OPTIONS.G108OPTIONS.BENEFITPERIOD( '3 month' 1 '6 month' 1 '12 month' 2 '24 month' 3 '5 year/5 year' 4 'to age 65' 4);
END

TABLE FILE G108ASSUMPTIONS
BY G108OPTIONS.G108OPTIONS.BP1
WHERE G108ASSUMPTIONS.G108ASSUMPTIONS.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE HOLD AS HDLVALS1 FORMAT ALPHA
END
-RUN

*This returns the number of records retrieved
-*so you'll know how many times to loop on the read.
-SET &OPTION_COUNT1 = &LINES;

TABLE FILE G108ASSUMPTIONS
BY G108OPTIONS.G108OPTIONS.BP2
WHERE G108ASSUMPTIONS.G108ASSUMPTIONS.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE HOLD AS HDLVALS2 FORMAT ALPHA
END
-RUN

*This returns the number of records retrieved
-*so you'll know how many times to loop on the read.
-SET &OPTION_COUNT2 = &LINES;

TABLE FILE G108ASSUMPTIONS
BY G108OPTIONS.G108OPTIONS.BP3
WHERE G108ASSUMPTIONS.G108ASSUMPTIONS.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE HOLD AS HDLVALS3 FORMAT ALPHA
END
-RUN

-*This returns the number of records retrieved
-*so you'll know how many times to loop on the read.
-SET &OPTION_COUNT3 = &LINES;

TABLE FILE G108ASSUMPTIONS
BY G108OPTIONS.G108OPTIONS.BP4
WHERE G108ASSUMPTIONS.G108ASSUMPTIONS.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE HOLD AS HDLVALS4 FORMAT ALPHA
END
-RUN

-*This returns the number of records retrieved
-*so you'll know how many times to loop on the read.
-SET &OPTION_COUNT4 = &LINES;

-IF &QUALIFIER EQ 'STD' GOTO STDTD;
-IF &QUALIFIER EQ 'LTD' GOTO LTDTD;

-IF &STATE EQ 'LA' GOTO LALTDTD;

SET PAGE-NUM=OFF
TABLE FILE G108ASSUMPTIONS
BY APLPROPOSALID NOPRINT
WHERE G108ASSUMPTIONS.G108ASSUMPTIONS.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=report, size=10, $
OBJECT=STRING, NAME='TotalDisLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.124 0.605), style=bold, METADATA='', $
OBJECT=STRING, NAME='L1', TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.462), METADATA='', $
OBJECT=STRING, NAME='L2', TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 1.350), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.55), METADATA='', $

-SET &STARTTOP = &STARTTOP + 1.550;

-GOTO TDEND

-LALTDTD
OBJECT=STRING, NAME='TotalDisLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.124 0.605), style=bold, METADATA='', $
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 0.875), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.462), METADATA='', $
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 1.350), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.55), METADATA='', $

-SET &STARTTOP = &STARTTOP + 1.550;
-GOTO TDEND

-STDTD

SET PAGE-NUM=OFF
TABLE FILE APLPROPOSAL
BY APLPROPOSALID NOPRINT
WHERE APLPROPOSAL.APLPROPOSAL.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=report, size=10, $
OBJECT=STRING, NAME='TotalDisLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.124 0.605), style=bold, METADATA='', $
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.462), METADATA='', $

-SET &STARTTOP = &STARTTOP + 0.482;
-GOTO TDEND

-LTDTD
SET PAGE-NUM=OFF
TABLE FILE APLPROPOSAL
BY APLPROPOSALID NOPRINT
WHERE APLPROPOSAL.APLPROPOSAL.APLPROPOSALID EQ &APLPROPOSALID;
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=report, size=10, $
OBJECT=STRING, NAME='TotalDisLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.124 0.605), style=bold, METADATA='', $
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXXfull></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.55), METADATA='', $

-SET &STARTTOP = &STARTTOP + 1.550;
-GOTO TDEND


-TDEND

OBJECT=STRING, NAME='SucessiveDisLbl', TEXT='<font face="ARIAL" size=10>XX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.125 0.333), style=bold, METADATA='', $

-IF &STATE EQ 'NH' GOTO NHSD;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.563), METADATA='', $

-SET &STARTTOP = &STARTTOP + 0.550;
-GOTO SDRPTEND

-NHSD

-REPEAT :LOOP3 FOR &CNT FROM 1 TO &OPTION_COUNT3
-READ HDLVALS3, NOCLOSE &BPVAL3.I2

-IF &BPVAL3 EQ 2 GOTO NHLTD;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XX[/i]<br>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.563), METADATA='', $
-GOTO BLOOP1

-NHLTD
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<br>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.563), METADATA='', $

-BLOOP1
-SET &STARTTOP = &STARTTOP + 0.620;

-:LOOP3
-CLOSE HDLVALS3

-SDRPTEND

OBJECT=STRING, NAME='MinimumLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.250 0.167), style=bold, METADATA='', $
-IF &STATE EQ 'MO' GOTO MOMINDEV;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.290), METADATA='', $

-GOTO MINRPTEND

-MOMINDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.290), METADATA='', $

-MINRPTEND
-SET &STARTTOP = &STARTTOP + 0.300;

OBJECT=STRING, NAME='WaiverLbl', TEXT='<font face="ARIAL" size=10>XXX</font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.292 0.167), style=bold, METADATA='', $

-REPEAT :G108LOOP2 FOR &CNT FROM 1 TO &OPTION_COUNT2
-READ HDLVALS2, NOCLOSE &BPVAL2.I2

-IF &BPVAL2 EQ 1 GOTO 3MONTHWOP;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.667),  METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.667;

-GOTO BLOOP2

-3MONTHWOP
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.167),  METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.197;

-BLOOP2

-:G108LOOP2
-CLOSE HDLVALS2


-* G108 Return to Work - Partial Disability
OBJECT=STRING, NAME='ReturnToWorkLbl', TEXT='<font face="ARIAL" size=10>XXX-<BR>XXX<BR>X</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.125 0.500), style=bold, METADATA='', $
-REPEAT :LOOP1 FOR &CNT FROM 1 TO &OPTION_COUNT1
-READ HDLVALS1, NOCLOSE &BPVAL1.I2

-IF &BPVAL1 EQ 2 GOTO SIX;
-IF &BPVAL1 EQ 3 GOTO TWELVE;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.962), METADATA='', $
-GOTO BOTTOMLOOP

-SIX
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.962), METADATA='', $
-GOTO BOTTOMLOOP

-TWELVE
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.962), METADATA='', $

-BOTTOMLOOP
-SET &STARTTOP = &STARTTOP + 0.962;

-:LOOP1
-CLOSE HDLVALS1

-IF &QUALIFIER EQ 'STD' GOTO STDSURVIVE;
OBJECT=STRING, TEXT='<font face="ARIAL" size=10>XXX</font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.5), style=bold, METADATA='', $
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.917), METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.917;
-GOTO SURVIVEEND

-STDSURVIVE
OBJECT=STRING, TEXT='<font face="ARIAL" size=10> </font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.5), style=bold, METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.000;
-GOTO SURVIVEEND

-SURVIVEEND

-IF &QUALIFIER EQ 'LTD' GOTO LTDLIMIT;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10>XX<BR>XX</font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.5), style=bold, METADATA='', $

-IF &STATE EQ 'VA' GOTO VALIMIT;
-IF &STATE EQ 'SD' GOTO SDLIMIT;
-IF &STATE EQ 'KS' GOTO KSLIMIT;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XX:<BR>XXX</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.626), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.626;
-GOTO LIMITEND

-VALIMIT
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.626), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.626;
-GOTO LIMITEND

-SDLIMIT
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.626), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.626;
-GOTO LIMITEND

-KSLIMIT
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.626), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.626;
-GOTO LIMITEND

-LTDLIMIT

OBJECT=STRING, TEXT='<font face="ARIAL" size=10> </font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.5), style=bold, METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.000;

-GOTO LIMITEND

-LIMITEND

-IF &QUALIFIER EQ 'STD' GOTO STDADJUST;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10>XXX<BR>XXX</font>',
POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.5), style=bold, METADATA='', $

-IF &STATE EQ 'VA' GOTO VAADJUST;
-IF &STATE EQ 'SD' GOTO SDADJUST;
-IF &STATE EQ 'KS' GOTO KSADJUST;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.577), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.577;
-GOTO ADJUSTEND

-VAADJUST
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.577), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.577;
-GOTO ADJUSTEND

-SDADJUST
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.577), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.577;
-GOTO ADJUSTEND

-KSADJUST
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX:<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.577), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.577;
-GOTO ADJUSTEND

-STDADJUST
OBJECT=STRING, TEXT='<font face="ARIAL" size=10> </font>',POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.354 0.1), style=bold, METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.000;

-GOTO ADJUSTEND

-ADJUSTEND

OBJECT=STRING, NAME='AlLbl', TEXT='<font face="ARIAL" size=10>XXX<BR>XXt</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.292 0.292), style=bold, METADATA='', $
OBJECT=STRING, NAME=xxx, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>', POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.292),  METADATA='', $
-SET &STARTTOP = &STARTTOP +  0.352;


-IF &STARTTOP LT 8.50 GOTO MIRPT;

WANT A PAGE-BREAK HERE
-SET &STARTTOP=0.854;
PAGELAYOUT=3, NAME='Page layout 3', text='Page layout 3', TOC-LEVEL=1, METADATA='BOTTOMMARGIN=0,TOPMARGIN=0,LEFTMARGIN=0,RIGHTMARGIN=0,', $

-MIRPT
OBJECT=STRING, NAME='MentalIllnessLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.417 0.292), style=bold, METADATA='', $
-REPEAT :LOOP4 FOR &CNT FROM 1 TO &OPTION_COUNT4
-READ HDLVALS2, NOCLOSE &BPVAL2.I2

-IF &BPVAL2 EQ 2 GOTO 6MENTAL;
-IF &BPVAL2 EQ 3 GOTO 12MENTAL;
-IF &BPVAL2 EQ 4 GOTO 24MENTAL;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.562), METADATA='', $
-GOTO BOTTOMLOOP4

-6MENTAL
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.562), METADATA='', $
-GOTO BOTTOMLOOP4

-12MENTAL
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.562), METADATA='', $
-GOTO BOTTOMLOOP4

-24MENTAL
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>[i]XXX[/i]<BR>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.562), METADATA='', $

-BOTTOMLOOP4
-SET &STARTTOP = &STARTTOP + 0.562;

-:LOOP4
-CLOSE HDLVALS4

-IF &STARTTOP LT 8.50 GOTO EXCLUSRPT;

WANT A PAGE BREAK HERE
-SET &STARTTOP=0.854;
PAGELAYOUT=3, NAME='Page layout 3', text='Page layout 3', TOC-LEVEL=1, METADATA='BOTTOMMARGIN=0,TOPMARGIN=0,LEFTMARGIN=0,RIGHTMARGIN=0,', $

-EXCLUSRPT
OBJECT=STRING, NAME='ExclusionsLbl', TEXT='<font face="ARIAL" size=10>XXX</font>', POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.167 0.292), style=bold, METADATA='', $

-IF &STATE EQ 'IA' GOTO IAEXDEV;
-IF &STATE EQ 'MO' GOTO MOEXDEV;
-IF &STATE EQ 'NC' GOTO NCEXDEV;
-IF &STATE EQ 'NE' GOTO NEEXDEV;
-IF &STATE EQ 'OK' GOTO OKEXDEV;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND


-IAEXDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND

-MOEXDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND

-NCEXDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND

-NEEXDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND

-OKEXDEV

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>XXX</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.042), METADATA='', $

-GOTO EXRPTEND

-EXRPTEND
-SET &STARTTOP = &STARTTOP + 1.062;

-IF &STARTTOP LT 9.00 GOTO PERPT;

WANT A PAGE BREAK HERE
-SET &STARTTOP=0.854;
PAGELAYOUT=3, NAME='Page layout 3', text='Page layout 3', TOC-LEVEL=1, METADATA='BOTTOMMARGIN=0,TOPMARGIN=0,LEFTMARGIN=0,RIGHTMARGIN=0,', $

-PERPT
OBJECT=STRING, NAME='xLbl', TEXT='<font face="ARIAL" size=10>x<BR>x</font>',POSITION=(0.667 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(1.125 0.292), style=bold, METADATA='', $

-IF &TAKEOVER EQ 0 GOTO NOTAKEOVER;
-IF &STATE EQ 'SC' GOTO SCNOTAKEOVER;
-IF &STATE EQ 'NH' GOTO NHNOTAKEOVER;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.350), METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.350;
-GOTO NOTAKEOVER

-SCNOTAKEOVER
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.350), METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.550;
-GOTO NOTAKEOVER

-NHNOTAKEOVER
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 0.350), METADATA='', $
-SET &STARTTOP = &STARTTOP + 0.550;
-GOTO NOTAKEOVER

-NOTAKEOVER

-IF &STATE EQ 'NH' GOTO NHPREEXIST;
-IF &STATE EQ 'UT' GOTO UTPREEXIST;

-IF &RATING EQ 'Preferred' GOTO PREFERREDLOGIC;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><fullxxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.050;
-GOTO ENDPREEXISTING

-PREFERREDLOGIC

-IF &QUALIFIER EQ 'STD' GOTO STDPREFERRED;
-IF &QUALIFIER EQ 'LTD' GOTO LTDPREFERRED;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.350;
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-STDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-LTDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-NHPREEXIST
-IF &RATING EQ 'Preferred' GOTO NHPREFERREDLOGIC;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.250;
-GOTO ENDPREEXISTING

-NHPREFERREDLOGIC

-IF &QUALIFIER EQ 'STD' GOTO NHSTDPREFERRED;
-IF &QUALIFIER EQ 'LTD' GOTO NHLTDPREFERRED;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.350;
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx</full></font>',POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-NHSTDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-NHLTDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING


-UTPREEXIST
-IF &RATING EQ 'Preferred' GOTO UTPREFERREDLOGIC;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.250;
-GOTO ENDPREEXISTING

-UTPREFERREDLOGIC

-IF &QUALIFIER EQ 'STD' GOTO UTSTDPREFERRED;
-IF &QUALIFIER EQ 'LTD' GOTO UTLTDPREFERRED;

OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-SET &STARTTOP = &STARTTOP + 1.350;
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-UTSTDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-UTLTDPREFERRED
OBJECT=STRING, TEXT='<font face="ARIAL" size=10><full>xxx.</full></font>',
POSITION=(2.167 &STARTTOP), MARKUP=ON, WRAP=ON, DIMENSION=(5.542 1.250), METADATA='', $
-GOTO ENDPREEXISTING

-ENDPREEXISTING

ENDSTYLE
END


 

This message has been edited. Last edited by: Kerry,


DevStudio Version 7701
WebFocus 7.7 Windows Server 2003 PDF Format
 
Posts: 12 | Registered: October 08, 2010Report This Post
Gold member
posted Hide Post
If you want to page break when a particular condition exists, you can try the WHEN statement on one of your sort fields. However, I've had trouble getting this to work sometimes and I actually have a case opened. They tell me that PDF output may be the culprit. In theory, the WHEN should work but it was adding a page break before my grand total that I didn't want.

Maybe not the best answer, but could be something to try.


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Expert
posted Hide Post
OMG, my eyes glazed over.



jseaburn is right, adding a page break with a WHEN is the simple way.

Another way, far morte complex, you be to keep track of where the reports are on each page, by estimating the size of the report, and then breaking at the correct point.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
Yay! I got one right today! Honestly, I had trouble sifting through the code myself...


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Member
posted Hide Post
Thanks for the input. I will try the WHEN statement. I know it was a lot of code!!


DevStudio Version 7701
WebFocus 7.7 Windows Server 2003 PDF Format
 
Posts: 12 | Registered: October 08, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Manual Page Break

Copyright © 1996-2020 Information Builders