3 records per sheet

gsmackay

Report has a sub-report already defined in it. It has been working fine for years with one "label" per 8.5x11 sheet of paper. Now the client ordered preprinted forms with three (3) "labels" per sheet. How do I get my .frf to print to these new forms? I've tried setting the form size to 3.67" high which prints the first "label" on the page fine, but issues a form feed and prints record 2 on the next page.

{edited}
OK, I finally got two per page, but I can not get the third one to print. A page 11" tall is roughly 3.67" split in thirds right? So I placed the data band at the top (0.00) and made the band 3.67" high. The first two labels print perfect, and the third one is skipped. I have to reduce the height of the band to 3.55" before the third one will print, but then the labels are not spaced out properly on the pre-printed form. I have checked the magin settins and they are all zero. What am I missing???
{/edit}

gordk

Hi
you may have to do some working around here
If on a dot matrix printer be careful line feeds are 1/6 inch so rounding errors may
create problems
first label stock is usually a matrix of down acrros or down only per page.
the page usually has top margin waste space, bottom waste space, side margins waste space, and vertical waste between labels and horiz waste between if more than 1 accross.
in handling, size a memo to label size, for vertical space between labels add a child band and control its visibility from the mdbands obp event turn it on for first 2
and off for 3rd.
use the [Line#] variable with mod function in your expression
ie something like
child1.visible := Not [[Line#] mod 3 = 0];
or if multipage use your own var to track wich row you are in reset it to 0 at start of each page.
regards

gsmackay

I'm using laser printers, not dot matrix. I'll try playing around with your idea tho, but I'm guessing I'll be able to get the third label to print but spaced down far enough. I'll see. Thanks for the help.