Page History
...
Use Break-On with columns that have been sorted. For example:
Code Block |
---|
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 Break-On is to print a blank line, then three asterisks (***) in the column for the Break-On column, then another blank line. The report then continues. |
...
Option | Description |
---|---|
text | Use text to substitute for the three asterisks normally 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 is 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 one line of data. Useful in condensing a report. |
'L' | Line. Suppresses the blank line that usually precedes the break data line. Use this when you want to condense a report. This 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 breaks. |
'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 at the break line in place of the three asterisks. |
Example
Code Block |
---|
* List Customer by State breaking on State and * placing the value of the State in the Break text stmt = 'LIST CUSTOMERS CUSTOMER_NAME BREAK-ON STATE ' stmt:= ' " ' : " 'V' ": ' " INVOICE_TOTAL BY STATE' Run_Report("",stmt) |