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, 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 contents of an L record are as follows:
Control area for L records:
- Byte position
- Description
- 01
- Value record identifier (L)
- 02
- Continuation indicator. Indicates whether the current record
is continued to a data continuation record (see Data continuation records (C)):
- C for continued
- 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
- Blank if not continued
(See notes 1 and 2 following
the descriptions.)
Record data area for L records (fixed area):
- Byte position
- Description
- 01
- Blank
- 02-04
- Report part indicator 110 = Page heading 120
= Page footing 13n = Break heading (n is break number, 1-6)
15n = Break footing (n is break number, 1-6) 170 =
Column heading 171 = Detail heading 180 = Detail line
181 = Group summary line 190 = Final footing
- 05
- Blank
- 06-13
- 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).
- Byte position
- Description
- 06
- 1
- 07
- Data
- 08
- Text
- 09
- Separator
- 10
- Column wrap. See note 3.
- 11
- Line wrap. See note 3.
- 12
- Second data line (across reports only). See note 4.
- 13
- Reserved
- 14
- Blank
id=repline.Record data area for L records (report line):
- Byte position
- Description
- 01-end
- The actual formatted report line
Example of an L record:
L 151 11100000 DEPARTMENT TOTALS 93,659.45
(Break1 footing line containing text and data)
Notes:
-
A C record immediately follows an L record marked
with a continuation character in byte 2 of the control area.
-
When D is specified for the continuation indicator
in the control area, it means that the current record is too long
to fit into a single physical record, and that, 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 the DBCS data being continued.
- 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 given L format record means that the column data or wrapped
line is continued on a following L format record.
- Across reports containing 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.
