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,

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,

On line 20 or so where I do a SUBTOTAL Page-Break

Sorry, my previous post was a combination of my two posts...

Can you provide this dilemma using the CAR file?

We have delete all sample files

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 *

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.

I took the column occurs off with no success. it still printing multiple records per page.

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.

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

What format is the report? Page breaks only work with some formats.

HTML - Web Bowser

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.

Thanks;
Do I need to set or send something different to the printer?

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.

If you really want one, you can do a page-break in HTML as Susannah and Tony show in a forum post HERE.

You can also use "<p style="page-break-before: always">" directly in your HTML as required.

Doug:
would that go after the wheere clause and before HEADING?

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.

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.

Good point Farncis.
DaveZ: Are you ready to close this? If so, go ahead, the instructions are right here if you need them.

In most languages like cobol, delphi and VB when command is executed it works.

quote:

In most languages like cobol, delphi and VB when command is executed it works.

And the difference with WebFOCUS would be???

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.

In report assist(MRE) the page break does not work, the average user can not go behind the scene and change code.

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: 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.