Report line records (L)

Each formatted line in a report is described by an L record. There is one L record for each line in the report.

Like other variable-format records (V, T, and R), L records consist of a control area followed by a record data area. The format of the control area is similar to the other records. The record data area is composed of a fixed area that precedes the formatted report line itself. The fixed area provides information about the report line that follows it. The format of an L record is shown in the following figure.

Figure 1. Format of an L record
This figure shows the format of an L record: a control area followed by a data area, which is divided into two parts: a fixed area and a report line.

The control area for an L record is shown in this table:

Table 1. Control area for an L record
Byte position Description
01 Value record identifier (L)
02 Continuation indicator

Indicates whether the current record is continued to a data continuation record:

  • C for continued

    A C record immediately follows an L record marked with a continuation character in byte 2 of the control area.

  • D for continued with DBCS delimiters SO and SI inserted at the end of the current record and the beginning of the data portion of the next record

    When D is specified for the continuation indicator in the control area, the current record is too long to fit into a single physical record. In the process of splitting up the record, SO (shift out) and SI (shift in) characters were added to the current and next records to preserve the integrity of any DBCS data that is continued.

  • Blank if not continued

The record data area for an L record is shown in this table. Bytes 6-13 are line type attributes. Byte 06 is always 1. Each byte in bytes 7 through 13 indicates the presence or absence of the corresponding line type attribute in the formatted report line (1 = attribute present, 0 = attribute absent).

Table 2. Record data area for an L record
Byte position Description
01 Blank
02-04
Report part indicator:

110 = Page heading
120 = Page footing
13n = Break heading
      (n is the break number, 1-6)
15n = Break footing
      (n is the break number, 1-6)
170 = Column heading
171 = Detail heading
180 = Detail line
181 = Group summary line
190 = Final footing
05 Blank
06 1
07 Data
08 Text
09 Separator
10 Column wrap

Attributes for column wrap (byte 10) and line wrap (byte 11) are used to indicate the continuation of a single logical report line to multiple physical report lines. The presence of either attribute in a L format record means that the column data or wrapped line is continued on a following L format record.

11 Line wrap

Attributes for column wrap (byte 10) and line wrap (byte 11) are used to indicate the continuation of a single logical report line to multiple physical report lines. The presence of either attribute in a L format record means that the column data or wrapped line is continued on a following L format record.

12 Second data line (across reports only)

Across reports that contain percent or cumulative sum columns can contain two data lines for each group (also break and final) summary. The first summary data line contains the cumulative percent or cumulative sum values of the column as computed across each unique across value. The second summary data line contains the cumulative percent or cumulative sum values of the column as computed down each group (in the report or within a control break). The second data line (byte 12) line type identifies the second data line in exported reports of this nature.

13 Reserved
14 Blank

The following example shows an L record for a break footing line in a report that contains text and data:

L  151 11100000    DEPARTMENT TOTALS     93,659.45