4D v13.4
BREAK LEVEL
- 4D Language Reference
-
- Printing
-
- Integration of PDFCreator driver under Windows
- ACCUMULATE
- BREAK LEVEL
- CLOSE PRINTING JOB
- Get current printer
- Get print marker
- GET PRINT OPTION
- Get print previewNew
- GET PRINTABLE AREA
- GET PRINTABLE MARGIN
- Get printed height
- Is in print previewNew
- Level
- OPEN PRINTING FORM
- OPEN PRINTING JOB
- PAGE BREAK
- PAGE SETUP
- Print form
- PRINT LABEL
- Print object
- PRINT OPTION VALUES
- PRINT RECORD
- PRINT SELECTION
- PRINT SETTINGS
- PRINTERS LIST
- Printing page
- SET CURRENT PRINTER
- SET PRINT MARKER
- SET PRINT OPTION
- SET PRINT PREVIEW
- SET PRINTABLE MARGIN
- Subtotal
BREAK LEVEL
| BREAK LEVEL ( level {; pageBreak} ) | ||||||||
| Parameter | Type | Description | ||||||
| level | Longint |
|
Number of break levels | |||||
| pageBreak | Longint |
|
Break level for which to do a page break | |||||
BREAK LEVEL specifies the number of break levels in a report performed using PRINT SELECTION.
You must execute BREAK LEVEL and ACCUMULATE before every report for which you want to do break processing. These commands activate break processing for a report. See the explanation for the Subtotal command.
The level parameter indicates the deepest level for which you want to perform break processing. You must have sorted the records with at least that many levels. If you have sorted more levels, those levels will be printed as sorted, but will not be processed for breaks.
Each break level that is generated will print the corresponding Break areas and Header areas in the form. There should be at least as many Break areas in the form as the number you pass in level. If there are more Break areas, they will be ignored and will not be printed.
The second, optional, argument, pageBreak, is used to cause page breaks during printing.
The following example prints a report with two break levels. The selection is sorted on four levels, but the BREAK LEVEL command specifies to break on only two levels. One field is accumulated with the ACCUMULATE command:
ORDER BY([Emp]Dept;>;[Emp]Title;>;[Emp]Last;>;[Emp]First;>) ` Sort on four levels
BREAK LEVEL(2) ` Turn on break processing to 2 levels (Dept and Title)
ACCUMULATE([Emp]Salary) ` Accumulate the salaries
FORM SET OUTPUT([Emp];"Dept salary") ` Select the report form
PRINT SELECTION([Emp]) ` Print the report
Product: 4D
Theme: Printing
Number:
302
Modified: 4D v11 SQL
ACCUMULATE
ORDER BY
PRINT SELECTION
Subtotal
