Hi All,

I have the following code :

  
DEFINE FILE CAR
LINE/I4 WITH MODEL= IF LINE EQ 10 THEN 1 ELSE LINE+1;
END
-RUN
TABLE FILE CAR
PRINT MODEL 
COUNTRY
LINE
ON LINE PAGE-BREAK
WHEN LINE EQ 10
END

The problem is related with PAGE-BREAK command, I want to break the page when the line is equal to 10.

This does not works, do you know why?

Page break is related to a BY field for what you want to do. If you only want ten lines of data on a page, consider the heading lines and any footing lines and do a SET on the LINES and PAGE.

Check out page formatting in the documentation.

I know that I can use LINES AND PAGE but I want to create a conditional PAGE-BREAK, for example:

  
ON LINE PAGE-BREAK
WHEN (LINE EQ 10) OR ((LINE EQ 5) AND (MODEL EQ 'XXXXX'))
 

Would have to test, but you still need to sort to do an ON whatever and I don't know if page-break is one you can put a condition on without doing some research. Never had to even try mostly why.

Car file is kind of hard to use as an example on this, but if you change the LINE to BY LINE your WHEN conditions should work. Of course if you don't want line on the report be sure to NOPRINT and do you want it within another BY field?

Traditionally I would do this with 2 DEFINEd fields.

DEFINE FILE CAR
LINE/I4 WITH MODEL= IF LINE EQ 10 THEN 1 ELSE LINE+1;
BREAKPOINT/I4 = IF ((LINE EQ 10) OR ((LINE EQ 5) AND (MODEL EQ 'XXXX'))) THEN BREAKPOINT+1 ELSE BREAKPOINT;
END
-RUN
TABLE FILE CAR
PRINT MODEL 
COUNTRY
BY BREAKPOINT NOPRINT
ON BREAKPOINT PAGE-BREAK
END

though there may be a 'more modern' approach.

Be careful using the words LINE and PAGE. These MAY be reserved words in WebFOCUS. I often use a variable such as LINE_CTR so that it is clearer to the next person who sees my code.

Others have already given the answer - you MUST have a BY field to to use PAGE-BREAK (that part is pretty clear from the documentation.) Given that, you've got to figure out another way to do it. Your problem is if you put BY LINE then you get the lines out of order so you need a combination of PAGENO and LINENO. Every time lineno reaches ten or model eq xxxx then increment pageno and set lineno=1.

Then a simple
BY PAGENO NOPRINT
BY LINENO NOPRINT
ON PAGENO PAGE-BREAK

Alan beat me to the punch - and jimster's note is also important!

I don't believe LINE would be a reserved word, LINES maybe. There is a list of watch words here.

The following code works for me:

DEFINE FILE CAR
LINE/I4 WITH MODEL = IF LINE EQ 10 THEN 1 ELSE LINE+1;
END

TABLE FILE CAR
HEADING
"PAGE <TABPAGENO"
PRINT MODEL
BY COUNTRY
BY LINE
ON LINE PAGE-BREAK
WHEN LINE EQ 10;
END

In the example given, the LINE was calculated with MODEL, and if you then do a BY on it, it never gets higher than 10, so it will never break the page. Adding the BY COUNTRY will do the trick.

Hope this helps ...

And if you compare the results of GamP's code to Alan's, you'll see that the lines and numbers are completely out of order by adding COUNTRY. Alan's code does the trick just fine.