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.
[ Previous Page | Next Page | Contents | Index ]
