Release 10.1A: OpenEdge Reporting:
Query/Results Administration and Development

> ## Label Field Selection defaults

> When you selects the label view for an active query for the first time, you can generate either a default mailing label or a custom mailing label for the query. Figure 2–2 shows the Label Field Selection dialog box you can use for either purpose.

> Figure 2–2: Label Field Selection dialog box

> The Label Field Selection dialog box displays ten possible label fields for default mailing labels. Most of the label fields contain a comma-separated list of strings used to search for database fields in the tables of the active query and generate the default label view for the query.

> ##### How Results determines values for the label fields

> Results uses the `MATCHES` function to match a database field name from a table in the active query to a label field. Each string listed in a label field represents a complete field name or a partial field name with wildcard characters. A period (`.`) in a string indicates that any single character is acceptable in that position; an asterisk (`*`) indicates that any group of characters is acceptable, including a null group of characters. See the "Label field considerations" section for more information about how Results generates labels for queries.

> ##### Label field considerations

> Before you alter the label selection information in the Label Field Selection dialog box, you must understand how Results generates default labels for queries:

> - The order of field names or partial field names specified for a label address field is important. Results attempts to find a matching database field for a label address field starting with the first string specified in the list associated with the label address field and ending with the last string in the list.

> - Precedence relationships between label address fields determine the default label layout associated with a query. A database field match with the Postal Code label address field suppresses the display of a database field that matches the Postal Code+4 label address field. A database field match with the City, State, Postal Code, or Postal Code+4 label address field suppresses the display of a database field that matches City+State+Zip label address field.

> - For queries based on multiple tables, Results searches for database fields for the default label starting with the last table specified in the query and ending with the first table specified.

> Based on this information, you can set up your own label selection parameters that determine how Results generates default labels for your users. However, Results always builds the labels in the format used in the United States.

> | To display and edit the parameters that Results uses to generate a default mailing label for a query:

> 1. Choose Query Site Admin Label Field Selection. The Label Field Selection dialog box appears:

> 2. Set up your own label selection parameters that determine how Results generates default labels for your users.

> 3. Choose OK to write the changes to the current `QC7` file and exit the dialog box.

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