The Report Designer department is exactly what it sounds like: it's where all Reports, Charts and Labels are created and which populate each Print menu on the Toolbars for each form and Datagrid.  When users choose a print option from the menu, they may be prompted for additional information.

Overview
Any designs you build in any of the designers are stored in the same database as your data, which means that all changes are available to all users without manually having to distribute new print options.

Every worksheet has a generic Labels print option. However sometimes you will need to combine data from more than one table to get the information you need. The Label Designer allows you to pull data from other tables for printing.

Please click here for general information about using the Toolbar, Form and Fields.

Creating A New Label Design
Click the 'New' button on the toolbar; then enter:

Label Title - This is what will be displayed in the Print Menu in the order you specify in the 'Menu Display Order' field (see below). If you want to put a line separator in the print menu BEFORE this print option, put a hyphen at the end of the name. For example, to put a line above a print option called 'Company Contacts' enter the Label Title as 'Company Contacts-' (no quotes, but note the hyphen at the end).

Table Name - This determines in which print menu this option will appear. For example, if you are creating a Label with Company information, choose the 'Company' table, which makes this report available from the Company print menu only.

Description - This isn't displayed anywhere on the print menu, but gives you a place to describe what the print option is. Since you can print a report about Labels (from the Label Designer print menu), users can get a short summary of what each print option is by reading the Description.

Menu Display Order - This lets you manually decide what order the print options are displayed in on the print menu. The items are sorted first by the number value in this field, then alphabetically by the Chart Title if the Menu Display Order numbers are the same.

Label Template - Choose the fields for each line on the Label Design by placing your cursor where you want to add the field in the textbox, then picking the fieldname from the drop-down list. You can use punctuation and spaces, etc., wherever you want in the template. Users can change this on the Label Setup dialog if you have the 'Allow Users to Edit' checkbox checked on this design.

Label Type - Choose one of the label types from the drop-down list. Users can change this on the Label Setup dialog if you have the 'Allow Users to Edit' checkbox checked on this design.

Mailing Labels - Uses a standard sheet of labels (Avery® 8160/8460 labels (1" x 2-5/8", 30 labels per sheet), or any other brand the same size). This label size has 3 columns of 10 labels.

Return Address Labels - Uses Avery® 5167/8167 labels (1/2" x 3/4", 80 labels per sheet), or a similar size in other brands. NOTE: You should limit the number of lines to four or less, with a font size of 8 or 9 or less.

Shipping Address Labels - Uses any 2” (high) x 4” (wide), 2 columns x 5 rows labels; can accommodate all five lines of text. You can make the font size larger on shipping labels as there is plenty of room.

Start on Label - Generally you will choose '1' to start on the first label on the first sheet, but you might have circumstances where you always start on a different label. Users can change this on the Label Setup dialog if you have the 'Allow Users to Edit' checkbox checked on this design.

No. of Copies - Set the default number of copies to print. Users can change this on the Label Setup dialog if you have the 'Allow Users to Edit' checkbox checked on this design.

Print Unique Values only - Check this option if you want to print unique or distinct values only from the fields selected in the Data Query. For example, you may want to print file folder labels so you can file hard copies of documents grouped by a field value. Users can change this on the Label Setup dialog if you have the 'Allow Users to Edit' checkbox checked on this design.

Print current record only - To print Return Address Labels, for example, check the “Print Current Record Only” option, which prints the record you see displayed in the Label Preview (which is the current record when you click any Label print menu option). Then one full sheet of labels will be created of the same record.

Allow Users to Edit - When this is checked and the user chooses this Label print option, the Label Setup dialog is displayed with the defaults you've chosen for this design. Users can then change any of these settings. If you have a Label Designer that should NEVER be changed (font size, etc.), uncheck this on the Label Designer record.