Generating Reports › Formatting Based on Column Value Control Break

Formatting Based on Column Value Control Break

You can make a report more readable by including a physical break, such as advancing one or more lines or providing some notation between each new value in the break field. You can specify control breaks on primary detail lines to group the data based on the value in a specific column.

For example, a report can include a control break each time the value of STATE changes. In the following Detail fill‑in, look at the column headed BREAK. Three fields are available to specify control break information.

• LVL or level specifies the control fields and their relative sequence. The field marked 1 is the highest level, 2 next, 3 next, and so on. A maximum of 9 levels is possible. In this example, there is one level, STATE.
• SKP designates the spacing between the control footing of one set and the control heading of the next. This value can be 1 through 9 lines inclusive, P to force a new page, or R to force a new page and begin page numbering from 1. In this example, SKP is specified as 2 to advance two lines.
• IND specifies whether the designated control field prints as part of the detail line. This does not affect whether the value prints in the control break footing. You can enter one of the following values:

N

Specifies the control field is not printed with detail line.

R

Specifies the control field is printed with every detail line.

Blank or G

Specifies the control field printed when value changes.

In this example, G specifies that the control field prints when the value of the field changes.

 =>
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
 IDEAL   : RPT DETAIL DEFN.      RPT CUSTRPT  (001) TEST        SYS: DOC  DISPLAY 
                                                                                
         Field Name, Literal,      Sort   Break  Function Column                
         Function, or               L A   L S I  T M M A  H W                   
 Command Arithmetic Expression      V /   V K N  O A I V  D ID Tab Edit Pattern 
                                    L D   L P D  T X N G  G TH                  
 ‑‑‑‑‑‑  ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑  ‑ ‑   ‑ ‑ ‑  ‑ ‑ ‑ ‑  ‑ ‑‑ ‑‑‑ ‑‑‑‑‑‑‑‑‑‑‑‑‑
 ======  =========== T O P =======  = =   = = =  = = = =  = == === =============
 000400  CUSTOMER.NAME              _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 000500  CUSTOMER.CITY              _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 000600  CUSTOMER.STATE             _ _   1 2 G  _ _ _ _  _ __ ___ _____________
 000700  CUSTOMER.OPEN$             _ _   _ _ _  _ _ _ _  _ __ ___ Z,ZZZ,ZZ9.99_
 ======  ========= B O T T O M ===  = =   = = =  = = = =  = == === =============

The following report segment only shows the output for the details under Tennessee, followed by a few details under Texas. This shows the control break as it appears between each state, the designated control break field. The value of the control break field is only listed with the first detail:

 .
 .
 .
SUNSTRAND BANKS             MEMPHIS     TN    932.00
BAY‑BANK AUTOMOBILES        NASHVILLE         543.21
AFTON INDUSTRIES            DALLAS      TX  1,234.51
GULF LAND USA               DALLAS          7,100.00
TEXAS LIFE & CASUALTY CO    DALLAS            543.21
CHEMICAL MUTUAL             FORT WORTH        931.72
PALMOLIVE INNS              FORT WORTH        758.93
 .
 .
 .

The previous sample shows the output when you specify IND as G or is blank. The following output shows the difference when you specify IND as N. The data in the control break field is not included on the detail line:

 .
 .
 .
SUNSTRAND BANKS             MEMPHIS           932.00
BAY‑BANK AUTOMOBILES        NASHVILLE         543.21
AFTON INDUSTRIES            DALLAS          1,234.51
GULF LAND USA               DALLAS          7,100.00
TEXAS LIFE & CASUALTY CO    DALLAS            543.21
CHEMICAL MUTUAL             FORT WORTH        931.72
PALMOLIVE INNS              FORT WORTH        758.93
 .
 .
 .

When you specify IND as R, the data in the control break field always prints on the detail line:

 .
 .
 .
SUNSTRAND BANKS             MEMPHIS     TN    932.00
BAY‑BANK AUTOMOBILES        NASHVILLE   TN    543.21
AFTON INDUSTRIES            DALLAS      TX  1,234.51
GULF LAND USA               DALLAS      TX  7,100.00
TEXAS LIFE & CASUALTY CO    DALLAS      TX    543.21
CHEMICAL MUTUAL             FORT WORTH  TX    931.72
PALMOLIVE INNS              FORT WORTH  TX    758.93
 .
 .
 .