Date: Fri, 29 Mar 2024 07:29:41 -0700 (PDT) Message-ID: <1549113150.531.1711722581022@wiki.srpcs.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_530_937898943.1711722581021" ------=_Part_530_937898943.1711722581021 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Break-On causes Run_Report to put a physical break in the report as the = value of a column changes.
Break-On COLUMN [options]
Use Break-On with columns that have been sorted. For example:
List CUSTOMERS By = STATE Break-On STATE
Option | Description |
---|---|
COLUMN | Each time the value of the column represented by= COLUMN changes, the report will indicate (with spacing, special characters= , etc.) that a new value is being printed. |
Options | Options can be specified that cause Break-On to = take specific action when a column changes value. The default action for Br= eak-On is to print a blank line, then three asterisks (***) in the column f= or the Break-On column, then another blank line. The report then continues.= |
Multiple Break-On columns are permissible. If more than one Break-On is = indicated, the report will break when the value of any one Break-On column = changes.
Break-On is frequently used in conjunction with the Total keyword. If To= tal is specified, subtotals will be printed at each breakpoint in the repor= t (refer to Total for details).
The specific action that Break-On will take when a column value changes = is dependent on the options specified by the user. Options can be included = with Break-On by specifying them after the column.
Text options are enclosed within double quotes. Control options ('B' or = 'UU') are single-quoted within double quotes. For example:
=E2=80=A6 Break-On EMPLOYEE_NO "Year to date:'UU'" =E2=80=A6
The following options are available.
Option | Description |
---|---|
text | Use text to substitute for the three asterisks n= ormally printed. The text will be truncated to fit into the column width of= the Break-On column. |
'B' | Break. Denotes the column whose breaking value i= s to be inserted into the heading. Must be used in conjunction with the 'B'= option in Heading. |
'D' | Data. Suppresses redundant totals by suppressing= the break data line entirely if the preceding data column contains only on= e line of data. Useful in condensing a report. |
'L' | Line. Suppresses the blank line that usually pre=
cedes the break data line. Use this when you want to condense a report. Thi=
s option does not override the 'U' option. Note: The Break-On= 'L' option suppresses a line, while the Heading 'L' option causes a blank = line to be inserted. |
'P' | Page. Prints a new page each time the column bre= aks. |
'U' | Underline. Prints a line over all subtotals. |
'UU' | Underline/Overline. Prints a line over and under= the subtotals. |
'V' | Value. Prints the value of the breaking column a= t the break line in place of the three asterisks. |
* List Customer by= State breaking on State and * placing the value of the State in the Break text stmt =3D 'LIST CUSTOMERS CUSTOMER_NAME BREAK-ON STATE ' stmt:=3D ' " ' : " 'V' ": ' " INVOICE_TOTAL BY STATE' Run_Report("",stmt)