Progress
Results User’s Guide
for UNIX


The Labels Module

This section of the tour shows you how to use some of the features in the Labels module to create mailing labels. For more information about the Labels module, see Labels Module."

If you save your definitions, you can leave the tour of the Labels module at the end of any section. When you want to start again, retrieve the saved definition and start where you last ended your session.

In this exercise, you create a mailing label and add field and text information to it. Before you start this tour, clear the Data Export definition from the screen.

  1. Select the Module option.
  2. Select the Labels module from the list.
  3. Select Define from the horizontal menu.
  4. Select the Customer file. Press END to end your selection.
  5. Results prompts you to accept the automatic selection of fields for the label. If you select No, the screen leads you through a manual selection process to pick the fields for the label. For more information on manual selection, see Labels Module."

  6. Select Yes.
  7. Status messages appear rapidly at the bottom of the screen as Results searches for address information in the active file. (If it can not find the files it needs in the first file, it looks in the other active files.) The label area expands, and the default fields appear in the Label Layout area:

    This is the default address label for the customer file when you perform the initial build in English against the mysports database. When you perform the initial build in another language or against your own database, you may see different fields. See "Database Administration" for details on different language versions of Results.

    Results prefixes the field names with the names of the database and files that contain them. A tilde (~) appears on line four to indicate that the information was too long to fit on the line and appears on the next line instead. When you run this label, the field information from line five appends to the end of line four.

    As mentioned earlier, this is the default layout for a label built from the mysports file. You can add other fields to this layout by pressing GET. Once you exit the definition window you can get back to edit it by selecting the Define option. Also, your database administrator can determine the field names used when generating labels automatically. For example, instead of mailing labels, it could automatically try to create packing labels. See "Database Administration" for details on changing the default fields for labels.

    Notice that Results numbers the lines of the label layout. Your label can be up to 66 lines long. Use your cursor keys to scroll through the window.

  8. Press GO to accept these settings.
  9. The label area returns to its original layout:

  10. Run the labels on your terminal.
  11. Again, the tilde ( ~ ) shows that the Postal-code field belongs on the line with the City and State fields. In some cases, an ellipsis (. . .) shows that the fields are too wide to fit in this screen. Again, these abbreviations do not appear in your labels or affect the way the labels print.

    The following page of labels appears:

    Notice that there are no blank lines for the Address2 field because the default value for Omit Blank Lines is yes.

    You can add more fields and text to this label, as well as adjust the layout and number of times each label prints.

  12. Return to the labels screen and select the Define option, then the Fields option.
  13. The Label Layout window becomes active again.

    The label definition fields are underlined or highlighted, depending on the monitor type.

    Follow these steps to insert a field a few lines below the last text line.

  14. Move the cursor to line 7.
  15. The message at the bottom of the screen indicates that you can press GET to insert fields.

  16. Press GET to display a list of fields you can insert:
  17. This list contains all of the fields in the customer file. (The database and file containing the field are listed in parentheses.) You can add any of these fields to your label. If you want to add more fields to a line than can fit in the Label Layout window, put the field names on two lines and type a tilde (~) at the end of the first line. When you run the labels, the two lines print as one.

  18. Select the Contact field.
  19. The Label Layout window appears:

    Instead of just printing the contact’s name at the bottom of the label, it is a good idea to send it to the attention of the contact. (For example, “Attn: Jane Smith.”)


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