I have a difficult printer collation issue and I wonder if anyone has approached it.
I am trying to print a bill of lading. I am printing on three part laser carbonless forms (pink/yellow/white). I will print a single bill at a time. These bills of lading often go over one page in length. I cannot predict how many detail lines will fit on each page, since the product description is a stretchable memo field and some descriptions are one line and other two lines. Finally, I want the three bills to print 'Customer Copy', 'Store Copy', and 'Office Copy' respectively. Got it? I could print the report three times in a row, changing a variable that is used to display the copy name. Unfortunately, since the paper is pre-stacked in the printer pink/yellow/white this does not work when the bill is two or more pages long. I noticed the extremely attractive COLLATION option in the help file. If I do this, I should (I assume, I haven't tried it) be able to print all the Page 1s (pink/yellow/white) then all the page 2s (pink/yellow/white) etc. The problem with this is I don't know how to change the name of the copy inside the report. I have a feeling it has to do with computing the page number in the page header, taking the modulus of the page number with respect to the number of copies, and use that as an index into an array of the copy names. Has anyone solved this problem already? -- Larry
