By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,557 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,557 IT Pros & Developers. It's quick & easy.

Printing a report on 5"x3" Labels

P: 2
I have a report which is based on a query with Customers table and Invoiceline Items table. I want to print more than one label if the number of line Items are more than 10. I need to know where to put the page break and how to count the line items.

I need to know how to set the height of report.

The Label sheet is a standard Avery sheet with 1" margin on the top and bottom,
1.75" Left and Right margin. There are 3 labels on each sheet 3" high and 5" wide.

I know label wizard will print only one line.

A step by step explanation will be highly appreciated.

Thanks.

nina
Oct 21 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

Pls communicate the dimensions for only 1 label...

Do just one label...

In the Print setup there is a Column tab. there you can locate the current height and width of your label and correct it...

If you have more than 1 label as width so you need to set up columns...

:)
Oct 27 '06 #2

P: 2
Hi,

Pls communicate the dimensions for only 1 label...

Do just one label...

In the Print setup there is a Column tab. there you can locate the current height and width of your label and correct it...

If you have more than 1 label as width so you need to set up columns...

:)
The size of each label is 5" wide and 3" high and there are 3 label on each sheet. I want to print 10 lines of data from invoice line Item table and if there are more than 10 lines they should print on the next label with the header on the top. It is a report which I am trying to print on the label.

Thanks.
Oct 31 '06 #3

PEB
Expert 100+
P: 1,418
PEB
So your report should have to sections...

Invoice Header, or Page header /it's better in your case Page Header where to store your data for the main part of your invoice...

In your detail section put the lines of your invoice...

And the report footer the end part of your invoice...

I've understood that in your sheet you have 3 labels that are one above other not one till other...

So to fit your 10 lines... Create them....

And try when you vizualize the information to see if 10 lines are fited...

The size of your report can be controled by page setup, choosing the colums section.

There is details about width and height of your report...

:)
Nov 4 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.