| **Navigation:**  [[clarion 7 faqs.htm|How To's and Troubleshooting]] > How to... >====== How to Print Labels ====== | [[how to print grand totals on a report.htm|{{btn_prev_n.gif|Previous page}}]][[clarion 7 faqs.htm|{{btn_home_n.gif|Return to chapter overview}}]][[how to print one record per page.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

NOTE: Before reading this FAQ, see a new and easier way to design labels using the [[tplwizardlabel.htm|Label Wizard]]

Printing labels simply means printing a multi-column report, that is, getting the report rows and columns to match up with the commercial label forms you use.

1.With a ruler, measure the height and width of the label paper, measure the height and width of the individual labels, and measure any top or left margins on your label paper. Make your measurements in inches.

2.Create a report of your address file.

Use the Report Wizard if you want, but don't worry about formatting yet. Just make sure the report contains all the address fields you need for your labels.

3.From the Application Tree, RIGHT-CLICK on your report procedure and choose **Report** from the popup menu.

4.Delete all report sections, except the **Detail** section.

5.From the IDE Menu, choose **View** {{c6h0013.jpg|C6H0013.jpg}} **Properties**, and verify that the **Report** is the selected component in the **Properties Pad**.

6.On the **General** category, choose //THOUS// in the **Units** property drop down list.

7.On the **Positions** category, set the margins you measured earlier.

The **X** property represents the left margin in thousandths of inches and the **Y** property represents the top margin in thousandths of inches. So, if the left margin of your label paper is 1/2 inch, type //500// in the **X** property. If the margin is zero, type //0// (zero) in the **X** property. Do the same for the top margin and the **Y** property.

8.In the **Position** category, set the **Height** and **Width** property values of the label paper.

In the **Width** group, verify that the Default property is set to //FALSE//, and type the paper width in thousandths of inches. Standard letter size paper is 8 1/2 inches, so type //8500//. Do the same for the paper Height property. Standard letter size paper is 11 inches, so type //11000//.

9.In the Report Worksheet, arrange your address fields in a vertical format, that is, one field below another near the left margin. Use the Alignment tools for precise alignment.

10.RIGHT CLICK on the Detail band and choose **Properties** from the popup menu.

11.In the **Position** tab, set the **Height** and **Width** properties of the individual labels.

In the **Width** group, verify that the **Default** property is set to //FALSE//, and type the label width in thousandths of inches (eg for a 2 1/2 inch label, type //2500//). Do the same for the label height.

12.Back in the Report Worksheet, readjust the position, size, and font of your address fields if necessary.

13.In the Report Designer toolbar, click on the **Print Preview** button {{printpreviewbut.jpg|PrintPreviewBut.jpg}} to preview your label report.

14.**Save and Close** the **Report Designer,** saving your changes.