Labels in reports

You can create mailing and other types of label in a labels report. The report is based on a table (or query or relation). Obviously for mailing labels the table should contain names and addresses. To create a label report from scratch, go to Database Manager and do the following:

  1. Right-click your mouse and select New followed by Report.

  2. In the "Create Report Wizard" select Labels.

  3. On the next page:

  1. On the next page select the table, query or relation on which you want to base the label report.

  2. Next, choose the fields that are to be displayed in the first line of the label report (e.g. these might be title, first name and surname fields). Use the Add button to transfer these from the Available Fields box to the Selected Fields box.

  3. On the next page you choose the fields that are to appear on the subsequent lines, making sure that you transfer them in the order you want (just use the Remove button if you make a mistake). Label reports display one record per label, using only the fields you have previously selected.

  4. Click on Finish to close the dialog and go into Report View.

The selected fields are displayed in a column in the Label section. Note that in the case of a label report you cannot rearrange the fields at the Report View stage (if you have made a mistake in the order of the fields which you haven’t corrected at the Wizard stage, then it is best to start again).

You can change the font style, the fore- and background colors, the border style, and so on, of any field. In addition you can exchange one field for another. To do any of these select the field you wish to format by clicking on it. Right-click and select Properties from the drop-down menu. In the "Format Object Style" dialog select from the available tabs: General, Color, Font, Style, Border, Align, Label.

You can also use the Draw toolbar on the left to insert shapes and text boxes.

To see what the labels will look like, click on the Print Preview button image\preview.gif on the toolbar.

At this point you can click on the Print button to print the labels, otherwise click on Close to return to Report View.

If the printing of the label contents appears to near to the edge of the physical label, select all the fields and drag them left and/or down.

To save and name the report, select the Save Report command from the File menu.

See:

Types of report