Progress
Results Administration
and Development Guide
Label Field Selection Defaults
When a user selects the label view for an active query for the first time, the user can generate either a default mailing label or a custom mailing label for the query.
Follow these steps to display and edit the parameters that Results uses to generate a default mailing label for a query:
- Choose Query
Site Admin
Label Field Selection. The Label Field Selection dialog box appears:
![]()
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.
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.
- Set up your own label selection parameters that determine how Results generates default labels for your users.
- Choose OK to write the changes to the current QC7 file and exit the dialog box.
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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |