Home » Developer & Programmer » Reports & Discoverer » Mailing Label Report (9.2)
Mailing Label Report [message #410542] Sun, 28 June 2009 06:37 Go to next message
Messages: 2
Registered: June 2009
Junior Member
Hi All,
I am working on a report in which i have to print the labels of PO's in an A4 size sheet.
The number of times the same PO Label should be printed should be equal to the quantity of the PO.
Need suggestions for the approach.

  • Attachment: sample.doc
    (Size: 38.50KB, Downloaded 708 times)
Re: Mailing Label Report [message #410964 is a reply to message #410542] Wed, 01 July 2009 05:46 Go to previous message
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Basically what i understand is that you want to repeat the number of labels EQUAL to quantity of that label.

So here is the idea to do this work.

Basically you have to repeat the rows equal to number of quantity in that particular row. e.g. Your PO table is as follow:

Item Code Qty
211.123 5
545.366 2

Thus you have to repeat row 1 by 5 times and row 2 by 2 times so that you get 7 prints of labels.

Here is guideline.
Create a table as follow:
Create table myno (to print number(3));

Insert into myno values (1);
Insert into myno values (2);
Insert into myno values (3);
. . . 
. . . 
Insert into myno values (999);

Insert 999 rows or equal to maximum number of quantity expected in future.

Now run following query

Select *
from PO a, myno b
where a.qty>=b.myno;

This will give you 7 rows

Good Luck
I think there are definitely more methods to achieve this task.

Previous Topic: print on specific excel sheet
Next Topic: Run report 6i from form in rtf format
Goto Forum:

Current Time: Fri Jul 10 02:36:41 CDT 2020