Thanks, Karen. You are right about my CODE. Thanks for the idea.
Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, November 27, 2009 4:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Bill of Lading Jim: I don't think your code would work. You are printing 4 copies of the exact same report. You cannot print 4 copies of a report, having each of the 4 copies have different information on it. I still think you'd be best replacing it with 4 exact same "print" commands, passing in a variable. Here's an alternative. I've done something similar to this: you change your report to be based on a temp table, with 4 copies of the data put in the temp table. Put a BreakCol column in your temp table, and make BreakCol = 1 for one copy of the data, BreakCol = 2 for the next copy of data, etc. Locate a break on the report for BreakCol with a page feed, so you end up with a 4-page report. In the break footer, you can use a report expression or a band eep to say something like (IFEQ(breakcol,1, 'Office Copy', ......)) nesting your 4 levels. If you do that you can use the one "print" command, with no copies parameter. Karen Jay, Karen, Bernard, We use paper that comes in four colors that is carbonless but each sheet is separate. They are put in a regular copier (not printer as such). I use this code on another report: PRINT KPRShiplist_Logo WHERE CONTROL# = .vControl# + ORDER BY CONTROL# MODEL# MATID# PARTNUM + OPTION PRINTER + |TRAY BYPASS TRAY + |COLLATION OFF + |COPIES 4 + |PRINTER_NAME \\K-SERVER\KONICA MINOLTA C351 PCL I want to be able to continue using this code but on the report itself I want a single variable that will print as mentioned below based on the page number. This report would print only one Bill (4 sheets) at a time so the page count would always be one - four pages.
