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] page-break on field does not work

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] page-break on field does not work
 Login/Join
 
Gold member
posted
this is my code, it is not breaking on employeeno:

-* Begin MR Prefix *-
-SET &SECTION='PREFIX';
-INCLUDE mrv/back365d.fex
-* End MR Prefix *-
TABLE FILE WF_ATTEND_BACK365_VIEW
-* Begin MR Suffix *-
-SET &SECTION='WHERE';
-INCLUDE mrv/back365d.fex
-* End MR Suffix *-
-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! displayTree=0
SUM WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS AS 'Occurs'
WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DAYS AS 'Days'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT NOPRINT
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO AS 'Employee No.' SUBTOTAL PAGE-BREAK
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEE_NAME AS 'Name'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.CHARGE_DATE AS 'Date'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.COMMENTS AS 'Comments'
WHERE (WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT EQ '012');
HEADING
"Employee"
"Status"
"&MDYY"
ON TABLE SET STYLE *
TYPE=REPORT,
GRID=OFF,
$
TYPE= HEADING,LINE=1,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=1,OBJECT=TEXT,ITEM=1,SIZE=9,$
TYPE= HEADING,LINE=2,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=2,OBJECT=TEXT,ITEM=1,SIZE=9,$
TYPE= HEADING,LINE=3,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=3,OBJECT=TEXT,ITEM=1,SIZE=9,$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS,
SIZE=10,
$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DAYS,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DAYS,
SIZE=10,
$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO,
SIZE=10,
$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEE_NAME,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEE_NAME,
SIZE=10,
$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.CHARGE_DATE,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.CHARGE_DATE,
SIZE=10,
$
TYPE=DATA, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.COMMENTS,
SIZE=10,
$
TYPE=TITLE, COLUMN=WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.COMMENTS,
SIZE=10,
$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END
-* End Report Assistant

-SET &SECTION='SUFFIX';
-INCLUDE mrv/back365d.fex

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


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
I don't see where you have aHow about adding the ON FIELDNAME PAGE-BREAK instead of the "PAGE-BREAK" in your "SUBTOTAL PAGE-BREAK" line.

This message has been edited. Last edited by: Doug,
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
On line 20 or so where I do a SUBTOTAL Page-Break


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
Sorry, my previous post was a combination of my two posts...

Can you provide this dilemma using the CAR file?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
We have delete all sample files


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Gold member
posted Hide Post
I added the page-break as requested to the ON statement with no success, code to follow, I also added footing to see if that would help , no luck there either.

SUM WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS AS 'Occurs'
WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DAYS AS 'Days'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT NOPRINT
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO AS 'Employee No.' SUBTOTAL
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEE_NAME AS 'Name'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.CHARGE_DATE AS 'Date'
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.COMMENTS AS 'Comments'
ON WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO PAGE-BREAK
WHERE (WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT EQ '012');
HEADING
"Employee"
"Status"
"&MDYY"
FOOTING
"(NEW) policy 711"
ON TABLE SET STYLE *


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Master
posted Hide Post
quote:
WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS AS 'Occurs'

This could be part of your problem, OCCURS is a reserved word. Also, if your data or titles are all the same formating it is easier to code and maintain your stylesheet if you use
TYPE=DATA,
SIZE=10,
$
TYPE=TITLE,
SIZE=10,
$

Rather than coding each field separately.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Gold member
posted Hide Post
I took the column occurs off with no success. it still printing multiple records per page.


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
Try working with code stripped to the bare minimum:

TABLE FILE WF_ATTEND_BACK365_VIEW
SUM 
WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.OCCURS
WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DAYS

BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT NOPRINT
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEE_NAME
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.CHARGE_DATE
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.COMMENTS

ON WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO SUBTOTAL PAGE-BREAK

WHERE (WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT EQ '012');

HEADING
"Employee"
"Status"
"&MDYY"

ON TABLE PCHOLD FORMAT PDF
END

I put the SUBTOTAL PAGE_BREAK in an ON command but this is not necessary. If the stripped code works, start adding the styling and other code until it breaks. If the stripped code does not work, Houston, we have a problem.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
ok I broke this down to a very simple report
sorting on employeeno, with a page break on employeeno, with page numbering on. I get page numbers along with the employeeno but when I print I still get multiple recs per page.

code follows:
-SET &SECTION='PREFIX';
-INCLUDE mrv/back365d.fex
-* End MR Prefix *-
TABLE FILE WF_ATTEND_BACK365_VIEW
-* Begin MR Suffix *-
-SET &SECTION='WHERE';
-INCLUDE mrv/back365d.fex
-* End MR Suffix *-
-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! displayTree=0
BY WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.EMPLOYEENO PAGE-BREAK
WHERE (WF_ATTEND_BACK365_VIEW.WF_ATTEND_BACK365_VIEW.DEPT EQ '012');
ON TABLE SET STYLE *
TYPE=REPORT,
GRID=OFF,
$
ENDSTYLE
ON TABLE SET HTMLCSS OFF
ON TABLE NOTOTAL
END
-* End Report Assistant

-SET &SECTION='SUFFIX';
-INCLUDE mrv/back365d.fex


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
What format is the report? Page breaks only work with some formats.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
HTML - Web Bowser


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
As long as the HEADING and Column Titles are repeated for each Employee Number, then PAGE-BREAK is working - there is no other notion of pages in HTML.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
Thanks;
Do I need to set or send something different to the printer?


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Virtuoso
posted Hide Post
If you're sending it to the printer, use PDF output. With PDF, you should be able to see the page breaks you're needing as well.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
If you really want one, you can do a page-break in HTML as Susannah and Tony show in a forum post HERE.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
You can also use "<p style="page-break-before: always">" directly in your HTML as required.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
Doug:
would that go after the wheere clause and before HEADING?


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
You could code it as heading line 1. But, you'd need to DEFINE it as a field using concatenations of the ≶ and > charaters. Otherwise it would be looking for a field named "p" as in "<p". "before" in The "page-break-before" can be changed to "after". Use which ever one works for you.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Why do we keep flogging this poor horse?

Search for 'PRINT HTML' in FocalPoint for many suggestions on printing a WebFOCUS generated HTML report (with or without page-break-before and page-break-after) or search for 'PRINT HTML' in Google to see oodles of suggestions regarding page-break-before and page-break-after.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Good point Farncis.
DaveZ: Are you ready to close this? If so, go ahead, the instructions are right here if you need them.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
In most languages like cobol, delphi and VB when command is executed it works.


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
quote:
In most languages like cobol, delphi and VB when command is executed it works.
And the difference with WebFOCUS would be??? Confused
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
Yes go ahead and close it, I will work on it from home when I get a chance, meanwhile I wrote 6 different queries for our HR department instead of one.


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Gold member
posted Hide Post
In report assist(MRE) the page break does not work, the average user can not go behind the scene and change code.


WebFOCUS 7.7.1
Windows 2000
Output: Excel and PDF
 
Posts: 82 | Registered: October 04, 2007Report This Post
Expert
posted Hide Post
This post has been very confusing to me because DaveZ specified a PDF output in his first post. And I don't know if this has anything to do with the release, but this works in 7.6.5.

-* HTML Tool
-* Created by Report Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! displayTree=0
TABLE FILE CAR
SUM CAR.BODY.RETAIL_COST AS 'Retail,Cost'
CAR.BODY.DEALER_COST AS 'Dealer,Cost'
COMPUTE 
-* COMPUTE BEGIN Profit
Profit/D12 = CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST;
-* COMPUTE END Profit
BY CAR.ORIGIN.COUNTRY AS 'Country' PAGE-BREAK
BY CAR.COMP.CAR AS 'Car'
HEADING
"Car Profit Report"
ON TABLE SET STYLE *
TYPE=REPORT,
   GRID=OFF,
 $
TYPE= HEADING,LINE=1,JUSTIFY=CENTER,$
TYPE= HEADING,LINE=1,OBJECT=TEXT,ITEM=1,STYLE=BOLD,SIZE=12,COLOR=RGB(255 69 0),FONT='Comic Sans MS',$
TYPE=TITLE, COLUMN=CAR.BODY.RETAIL_COST,
   STYLE=BOLD,
 $
TYPE=TITLE, COLUMN=CAR.BODY.DEALER_COST,
   STYLE=BOLD,
 $
TYPE=TITLE, COLUMN=Profit,
   STYLE=BOLD,
 $
TYPE=DATA, COLUMN=CAR.ORIGIN.COUNTRY,
   JUSTIFY=RIGHT,
 $
TYPE=TITLE, COLUMN=CAR.ORIGIN.COUNTRY,
   STYLE=BOLD,
   JUSTIFY=RIGHT,
 $
TYPE=DATA, COLUMN=CAR.COMP.CAR,
   JUSTIFY=RIGHT,
 $
TYPE=TITLE, COLUMN=CAR.COMP.CAR,
   STYLE=BOLD,
   JUSTIFY=RIGHT,
 $
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
END
-* End Report Assistant

I have never heard of a page break not working unless you were doing TABLEF and the data was not sorted or you had mixed case data and the upper case stuff sorted differently than the lower case stuff.

Dave, have you opened a case? Is that what your last post meant?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
Ginny: Yes, this has been a bit confusing. The request for HTML, in addition to or insead of PDF, started in the 11:19 / 11:28 posts from Dave.
Dave: You do have what you need on this subject, right? If so, you need to close it as per the instructions here. If not, then open a case as per Ginny's sugestion.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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] page-break on field does not work

Copyright © 1996-2020 Information Builders