473,398 Members | 2,368 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

Printing a report on 5"x3" Labels

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
3 1253
PEB
1,418 Expert 1GB
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
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
1,418 Expert 1GB
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

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

Similar topics

16
by: Maciej Kalisiak | last post by:
I use this simple test in Python: def foo(i): print i foo(i+1) import sys sys.setrecursionlimit(1000000) foo(0) Now, my understanding is that I get the segfault when Python overruns the C
38
by: Jack Klein | last post by:
Many people, including me, like having hard copy books at hand, along with electronic editions. When I first heard of this book several months ago, I pre-ordered a copy. It arrived from...
4
by: wob | last post by:
Many thanks for those who responded to my question of "putting greek char into C string". In searching for an solution, I noticed that there are more than one version of "Extended ASCII...
2
by: Ned | last post by:
I'm having difficulty printing on a 4"x3" labels . I set the left margin to 0 but it always prints starting from the middle of the label on the X-axis (no matter what the margin settings are.) I...
4
by: Gary Brown | last post by:
Hi, Why are fn(object parameters) and fn(params object parameters)
17
by: arindam.mukerjee | last post by:
I was running code like: #include <stdio.h> int main() { printf("%f\n", 9/5); return 0; }
7
by: adurth | last post by:
Hi! I wanna copy all childnodes of the current nodes except those with basenames "name1" or "name2". Something like <xsl:copy-of select=" basename not equal ('name1' or 'name2') "/> Can...
29
by: FredBear | last post by:
I am just coming to grips with php, Dreamweaver and MySQL and I want to make a facility available for the members of the group I am creating my web site for. I want them to be able to print-out a...
3
by: zoeb | last post by:
Hi, I am declaring an array which carries x coordinates, however these will vary depending on the geometry the user enters. I have set my code up as follows, but get the "initializer element...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.