skip to main content
OpenEdge Reporting: Query/Results Administration and Development
Results Files : Editing the results.l file
 
Editing the results.l file
The results.l file resides in the aderes directory in the Progress product directory ($DLC\GUI). It contains the following default site settings:
*Characters used to delimit fields in address labels and functions in report headers and footers.
*Standard export format definitions used in the export view of a query.
*Standard label format definitions used in the label view of a query.
*Standard page size definitions used in the report view of a query.
Results uses the results.l file to perform the initial build of a QC7 file for a user site. The default settings in the results.l file are transferred directly to the QC7 file during the build. For more information about the results.l and QC7 files, see Chapter 2, “Administering Results.”
The following sections provide more information about the default settings in the results.l file. You can use this information to change the delimiter characters and implement new export, label, and page formats.
Note: If you introduce errors into the results.l file, you might encounter problems during the initial build of a QC7 file. Avoid editing existing export, label, and page formats.
Delimiter characters
By default, Results uses curly braces { } to delimit functions in report headers and footers. It also uses braces to delimit the fields in address, and other, labels. You can change these default settings by editing the results.l file before you perform the initial build. For example, seven‑bit character sets use the curly braces for special characters, so you can changes the results.l file to specify angle brackets < > as delimiter characters.
To change these delimiter characters, edit the following lines in the results.l file before the initial build:
 
left-delim= "{"
right-delim= "}"
Note: Do not specify the same character for the left and right delimiter. You can use square brackets [ ] as long as there are no arrays within your reports or labels. You cannot use parentheses ( ) because they interfere with the label generation code.
Standard export formats
The results.l file contains several lines that define the standard export formats available for use in the export view of a query. Each line that defines an export format has the following syntax:
 
Syntax 
export[integer]= "code[|code]..."
The integer argument is a unique integer value that identifies the export format definition. The integers used to identify export formats must be sequential. The code parameter followed by a value defines the export format. All codes specified for an export format must be enclosed within a single set of double quotes and must be separated using a vertical line ( | ). Table C–2 provides information about the different definitional codes for an export format.
 
Table C–2: Definitional codes for export formats
Code
Description
1=
Specifies an integer representing the ASCII value of a character to start each line of the export. If you want to specify more than one character, specify a comma‑separated list of integers. There is no default character for this setting.
2=
Specifies an integer representing the ASCII value of a character to end each line of the export. If you want to specify more than one character, specify a comma‑separated list of integers. There is no default character for this setting.
3=
Specifies an integer representing the ASCII value of a character to delimit each field of the export. If you want to specify more than one character, specify a comma‑separated list of integers. There is no default character for this setting.
4=
Specifies an integer representing the ASCII value of a character to separate each field in a line of the export. If you want to specify more than one character, specify a comma‑separated list of integers. There is no default character for this setting.
b=
Specifies the base date for a DIF export. The default value is the unknown value (?). If you do not specify a base date, then all dates are exported as character values.
d=
Specifies the data types to delimit as fields using the characters specified with the “3=” code. Data type specifications are represented as integer values.
1       CHARACTER
2       DATE
3       LOGICAL
4       INTEGER
5       DECIMAL
6       RAW
7       RECID
Do not separate data type integers with commas or spaces. For example, d=123 specifies the CHARACTER, DATE, and LOGICAL data types. The default value is an asterisk (*), representing all data types.
f=
Specifies “y” for a fixed width export. The default value is “n” for a variable‑width export.
h=
Specifies “y” to include field headers in the export. The default value is “n.”
i=
Specifies “y” if the export program (p=) requires a prepass to count records. The default value is “n.”
l=
Specifies a label for the export format. This label represents the format in Results.
p=
Specifies the name of the procedure that generates the export. Results currently supports the following export procedures:
e-pro    Progress export procedure
e-ascii    ASCII export procedure
e-dif    DIF export procedure
e-sylk    SYLK export procedure
The u-export.p procedure is a sample export procedure. See Chapter 3, “Programming Results,” for more information about this procedure.
t=
Specifies a name for the export format. Results uses this name to manage the format, so the name must be unique.
The following excerpt from the result.l file shows some export format definitions:
 
export[1]= "t=PROGRESS|p=e-pro|2=32,13,10|3=34|4=32|l=PROGRESS Export"
export[2]= "t=ASCII|p=e-ascii|2=13,10|3=34|4=44|l=Generic ASCII"
export[3]= "t=ASCII-H|p=e-ascii|h=y|2=13,10|3=34|4=44|l=ASCII w/headers"
 
 
 
 
export[11]= "t=DIF|p=e-dif|l=DIF (w/dates as strings)"
 
 
 
export[15]= "t=SYLK|p=e-sylk|l=SYLK"
Standard label formats
The results.l file contains several lines that define the standard label formats available for use in the label view of a query. Each line that defines a label format has the following syntax:
 
Syntax 
label[integer]= "code[|code]..."
The integer argument is a unique integer value that identifies the label format definition. The integers used to identify label formats must be sequential. The code parameter is a special code followed by a value that defines the label format. All codes specified for a label format must be enclosed within a single set of double quotes and must be separated using a vertical line ( | ). Table C–3 provides information about the different definitional codes for a label format.
 
Table C–3: Definitional codes for label formats 
Code
Description
a=
Specifies the number of labels across the printed page. The default value is 1.
c=
Specifies a name for the label format. This name represents the format in Results. Must be a unique name.
d=
Specifies the width and height of the label in inches. For example, 3‑1/2 x 1. Separate the width and height values using an x. The width value must be first. Specifies fractional values by separating the numerator and denominator values with a forward slash ( / ). If the fractional value is preceded by a whole number, separate the whole number from the fraction using a hyphen (-).
h=
Specifies the height of the label in lines.
l=
Specifies the number of lines between labels. The default value is 1.
s=
Specifies the horizontal space between labels in characters. The default value is 0.
w=
Specifies the width of the label in characters.
x=
Specifies the left margin of the paper in characters. The default value is 0.
The following excerpt from the result.l file shows some label format definitions:
 
label[1]= "*Standard Label Sizes"
label[2]= "d=3-1/2 x 15/16 in|w=35|h=5|c=1-wide"
label[3]= "d=3-1/2 x 15/16 in|w=35|h=5|a=2|s=2|c=2-wide"
                  .
                  .
                  .
label[14]= "*Avery Catalog Labels"
label[15]= "d=3-1/2 x 15/16 in|w=35|h=5|c=Avery 4145 Address"
label[16]= "d=3-1/2 x 15/16 in|w=35|h=5|c=Avery 4010 Address (roll)"
If the first code parameter of a label format definition begins with an asterisk (*), Results ignores the definition and moves on to the next definition.
Standard page formats
The results.l file contains several lines that define the standard page formats available for use in the report view of a query. Each line that defines a page format has the following syntax:
 
Syntax 
page[integer]= "code[|code]..."
The integer argument is a unique integer value that identifies the page format definition. The integers used to identify page formats must be sequential. The code parameter is a special code followed by a value that defines the page format. All codes specified for a page format must be enclosed within a single set of double quotes and must be separated using a vertical line ( | ).
Table C–4 provides information about the different definitional codes for a page format.
 
Table C–4: Definitional codes for page formats 
Code
Description
c=
Specifies a label for the page format. This label represents the format in Results. Must be a unique name.
d=
Specifies the width and height of the label in inches (in) or millimeters (mm). For example, 210 x 297 mm or 3-1/2 x 1 in. Separate the width and height values using an x. The width value must be first. Specifies fractional values by separating the numerator and denominator with a forward slash ( / ). If the fractional value is preceded by a whole number, separate the whole number from the fraction using a hyphen (-).
h=
Specifies the page height in lines.
w=
Specifies the page width in characters.
The following excerpt from the result.l file shows some page format definitions:
 
page[1]= "d=8-1/2 x 11 in|w=85|h=66|c=Letter"
page[2]= "d=8-1/2 x 14 in|w=85|h=84|c=Legal"
page[3]= "d=11 x 17 in|w=110|h=102|c=Tabloid"
page[4]= "d=9-1/2 x 4-1/8 in|w=95|h=24|c=Envelope-#10"
page[5]= "d=229 x 162 mm|w=90|h=38|c=Envelope-C5"
page[6]= "d=220 x 110 mm|w=86|h=26|c=Envelope-DL"
page[7]= "d=7-1/2 x 3-7/8 in|w=75|h=23|c=Envelope-Monarch"
page[8]= "d=7-1/4 x 10-1/2 in|w=72|h=63|c=Executive"
page[9]= "d=297 x 420 mm|w=117|h=99|c=A3"
page[10]= "d=210 x 297 mm|w=82|h=70|c=A4"
page[11]= "d=148 x 210 mm|w=58|h=49|c=A5"
page[12]= "d=182 x 257 mm|w=71|h=60|c=B5"
page[13]= "d=7-1/3 x 11 in|w=73|h=66|c=35mm-Slide"