Now, user client ask you to create a report that outputs mailing labels.  First they ask you to generate mailing labels with three columns and then change it to 1.5” X 3.5” label format.

You will learn how to:  use report style “mailing label,” use the “query builder,” generate three columns label, change the font and size, change it to two columns label, use handlers on the layout model.

 

	More Resources by Google:

Remove the report from “object navigator.”

Click on the "create" icon to create a new report.

Use the “report wizard” option.

Checkmark "mailing label."

Use "query builder" to write a sql query.

Include the "customers" table, then close the window, and checkmark the columns you need.

Click on the "sql" icon to show the sql statement.

Close the window.  And click “OK.”

The sql statement was generated for you.

Click “NEXT.”

Select the columns into "mailing label text."

Use "New line", "space", "Dash", "comma", and "period" if you need them in the "mailing label text."

Notice my selection.

Click “NEXT.”

Select the draft template; then click “NEXT,” and “Finish.”

This is an example of a three column label.

Select the output object and change its font type and size.

Change the three column label to the two column label.

Click on the “layout model” icon.

Make the “Object Navigator” window and the “Layout Model” window side by side.

On “object navigator,” expand "Layout Model," “Main Section,” and “Body.”

The frame item can be selected either by using the “Object Navigator” or the “Layout Model” in the report editor.

Select the first "repeating group" frame.

Drag the frame to 1.5 by 3.5 inches.

Click on the text boilerplate.

Notice the handlers; drag them to the "repeating group" frame.

Select the text and change the font type and size.

Run the report.

This is an example of a two column label.

Change only the customer name font.

Select the “untitled” report and save it as report number 3 in the "iself" folder.

Now, you should practice this over and over, until you become a master at it.

Good Luck!