Crystal Reports 9 - Avery Labels 5160

[AZUser]

I'm new to Crystal Reports and am trying to print Avery labels 5160.

However, when I print the labels the first character in each line, in the left label, get cut off. Also, the labels are set to high up. In other words, when I print them, they do not print squarely on the label.

Is there any way I can solve this? The margins appear to be correct. When I try to change the margins, then it flips me to 2 colums instead of 3.

Any help or suggestions would be greatly appreciated.

Geoff C.
gcummings@arizbank.com

 

[synapsevampire]

You can adjust them slightly by increasing the height of the details section. When you say that they are too high

The margins set for your printer may have something to do with this also.

When you say that they are set too high, how many detail sections do you have?

It may be that you are only using the top 3, hence it looks off.

If the 4th detail section is not being printed, use formulas in lieu of dtaabase fields for each section, as in (assuming the last field is a country field which is not always filled in):

details A:
if isnull({table.country})
or
{table.country} = "" then
""
else
{table.name}

details B:
if isnull({table.country})
or
{table.country} = "" then
""
else
{table.add1}

You should be getting the idea, you can force the first row to be blank if there isn't a 4th field.

-k

 

[AZUser]

Thanks for you help. There is only 4 detail sections in the label. They print off fine with the exception they are printing slightly left and above the shape of the label.

Ex.

Joe Smith
ABC Company
1234 S. Main Street
Any Town USA

There are three columns in an Avery 5160, so lets say Joe Smith is in the first column. the J, A, 1,and A are like split down the middle, so you only see half the character. Addtionally, if I print the labels on to a blank sheet of paper, all the labels are move slightly left and up. So if they were to be printed on actual labels, I'd be missing the first charcter of each line and the only half of the top line (e.g. Joe Smith).

If they were to print on the label, there would be plenty of room for the information, so it isn't the fact I'm trying to put to much on one label. I guess it's a centering and left justifying issue.

Any ideas?

Geoff C

 

[synapsevampire]

Add in some aditional left/right margin until it looks right.

The same might work for the top/bottom margin.

Keep in mind thjat Crystal (Windows) renders for the printer being used, so another printer might look just fine.

-k

 

[AZUser]

Before I replied I tried working with the left and top margins, but I still can't get them on the label properly.

How do you add in additional left, right, top and bottom margins? Some of the changes I made, then made the labels have only 2 columns instead of three.

Sorry to keep bothering you about this. It's just very frustrating, because they appear to be fine in Print Preview, but then print wrong.

Geoff C.

 

[synapsevampire]

Adjusting the left should be tried in the File->Page Setup, perhaps in the File->Print setup.

You can also adjust the settings when creating the label report.

I generally don't have to make many adjustments there.

-k

 

[AZUser]

Thanks for your help. I was able to tweek the margins in the page set up so that all 3 columns fit properly.

thanks for you help.

Geoff