BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

How to create mailing labels

1. Open Crystal Reports

2. From the toolbar, select File > New > Mailing Label Report

3. Choose the data source and table(s)/view(s) you want to report on (In this example, I’ll be using the extreme database).

4. Click Next or link tables/views if nesscessary.

5. The next step is to add the fields you wish to display on your labels. Each field selected will represent a row on your label. If you have two fields (First Name, Last Name) and you select both, eEach one of those would appear on a seperate line and not on the same. It is best to add one (First Name) and than once the label is created, insert the last name field next to the first name field once the lable is created.

In my example, I wish to have the persons name, address, and city, state, and zip code displayed.  When selecting fields, I’ll select First Name, Address1, and City fields

6. Select the label type, printing direction, (if known, margin size, margins, and gap. If unknown, you can ignore these) Click Next to filter the data return or Finish if you do not wish to filter your data at this time. Your labels are now generated:

7. The next step is to add the fields you wish to display on your labels. Each field selected will represent a row on your label. If you have two fields (First Name, Last Name) and you select both, eEach one of those would appear on a seperate line and not on the same. It is best to add one (First Name) and than once the label is created, insert the last name field next to the first name field once the lable is created.

In my example, I wish to have the persons name, address, and city, state, and zip code displayed. When selecting fields, I’ll select First Name, Address1, and City fields

8. Select the label type, printing direction, (if known, margin size, margins, and gap. If unknown, you can ignore these) Click Next to filter the data return or Finish if you do not wish to filter your data at this time. Your labels are now generated:

Tagged , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

GET SOCIAL

QUICK TIP

It is best not to place fields used to group your report in the Details section.

ADVERTISMENT