3 records per sheet

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}

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 7:05PM
    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 ;)
  • edited 7:05PM
    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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.