Multiple records on same label

[Aerowolf]

I am using POs for one particular vendor that use the following format:

Line item #1 contains Part #, description, and finish.
Line item #2 contains Customer ID and sales order #.
Line item #3 contains a period as a separator on the page.

Each of the above is entered in the description field of each row (record).

For each item being ordered from this vendor, the above 3 line items are created. So I have 3 records that pertain to one item being ordered.

I want to print one label for each item being ordered on these POs. I want to print these labels on a standard Avery label sheet.

I need help in figuring out how to get each of the 3 line items on the same label.

Thanks

Edwin

 

[lbass]

I think you will have to manually create the label layout, instead of using the mailing label expert. You would insert a group on item and then use formulas like the following:

//{@reset} to be placed in the group header:
whileprintingrecords;
stringvar x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + {table.description} + chr(13);

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;

Go into the section expert and suppress the detail section. Also highlight details->format with multiple columns->layout->set the width (about 2) and gap (about .2), and check "format groups with multiple columns."

Resize the group footer and group header to get the correct display. Also change the page set up to correspond to the correct margins for the label sheet. For Avery 5260, I believe the margins should be: Left: .25, right .33, top .75, and bottom .25, although it might depend upon your printer, too.

You would need to format the display formula to "can grow" and remove the groupname from the group header.

-LB

 

[Charliy]

Are these three records from the same table, or are they coming from different tables?

Is there somthing you can group on and print the label as a group footer?