Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

> ## Modifying export types

> If none of the standard export types is suitable, you can temporarily modify an export type by overriding its default settings for one or more format attributes.

> | To modify an export type:

> 1. Determine which export type most closely matches the format you need.

> 2. Choose Options Custom Export and select the attribute you want to modify. Table 4–7 describes these attributes.

> Table 4–7: Custom export attributes
> Attribute | Description
> --- | ---
> Output headers | A Yes or No value that indicates whether Results will export the field name as the first line of the export.
> Fixed width | A Yes or No value that indicates whether the width of the fields is fixed. This value must be set to No unless you select ASCII Fixed-width (SDF) as your export type. The field width determines how Results exports the field data. For example, it defines the width of a character field. See the "Changing display field properties" section for information on formats.
> Record start | The initialization string at the start of a record. The initialization string is the set of characteristics that precedes the record data on each line of the export file. For example, an asterisk (*) might indicate the beginning of a line.
> Record end | The record termination string. The record termination string is the set of characters used to indicate the end of each record value.
> Field delimiter | The field delimiter string. The field delimiter string is the set of characters used to indicate the beginning and end of each field value.
> Field separator | The field separator string. The field separator string is the set of characters that separates each field value within a record.

> Depending which attribute you select, the following occurs:

> - The Output Headers and Fixed Width options toggle between Yes and No. When you set the value to Yes, a check mark appears next to the option name within the menu.
> - The Record Start, Record End, Field Delimiter, and Field Separator options display a dialog box that allows you to enter the codes for the string. See "Modifying strings" section for more information about modifying these attributes.

> ##### Modifying strings

> You can enter up to 16 codes for each string. Enter these codes from left to right and top to bottom:

> To enter a code, do one of the following:

> - Type the code using one of the formats in Table 4–8.

> Table 4–8: Code formats
> Format | Description | Example
> --- | --- | ---
> ’X’ | Literal character enclosed in single quotes. | ’C’
> ^X | Control character preceded by a circumflex. | ^Z
> ##h | One or two hex digits followed by the letter `h`. | 4Fh
> ###o | One, two, or three octal digits followed by the letter `o`. | 374o
> ### | A decimal number consisting of one, two, or three digits. | 027
> XXX | Control symbol. Choose the Pick From ASCII Table button. | Not applicable.

> - Choose Pick From ASCII Table and choose a control symbol from the ASCII Codes dialog box.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095