12. Report-Writer Statements : Report Setup Statements : .Break Statement—Specify Break Columns
 
Share this page                  
.Break Statement—Specify Break Columns
The .break statement specifies the break columns for the report and the order in which they should break.
The .break statement has the following format:
.break | .brk columnname{, columnname
The parameters for the .break statement are:
columnname
Name of a column in the table used as the basis for your report, or the label for a column in the result column list of the specified query.
The columnname can be expressed optionally as a delimited identifier or a variable. The comma (,) must be stated explicitly and cannot be part of a columnname variable. You can specify columnname as a delimited identifier by enclosing it in double quotes ("), if you have previously specified the .delimid statement.
$columnvariable
Variable whose value is a column name. The variable must be preceded with a dollar sign ($).