Thanks -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bob Thompson Sent: Sunday, April 13, 2008 6:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Duplex printing Issue - Rbase and Mayby not rbase
Steve, I sent a reply, but never saw it come through! I will resend it again to see what happens. -Bob ----- Original Message ----- From: Steve <mailto:[EMAIL PROTECTED]> Breen To: RBASE-L Mailing List <mailto:[email protected]> Sent: Sunday, April 13, 2008 4:37 PM Subject: [RBASE-L] - RE: Duplex printing Issue - Rbase and Mayby not rbase Ok Bob may not be available. Can any one give me a idea of how to use a form feed Thanks -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Steve Breen Sent: Sunday, April 13, 2008 4:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Duplex printing Issue - Rbase and Mayby not rbase Bob, Can you give an example of how you use a form feed, Thanks, Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bob Thompson Sent: Sunday, April 13, 2008 4:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Duplex printing Issue - Rbase and Mayby not rbase Steve, Most printers are controlled by the windows printer driver. In the driver, you normally have options such as "Print Order - Front to Back Back to Front" or "Last page first" Options such as COLLATE will group page numbers. Duplex printers often have options to have duplex along left side or top. Depending on the printer, there may be many options. The main point is that the printer controls all duplex functions and the driver has to be set to produce what you desire. So to answer your question, which prints first, is whatever you have your driver set to do. In most cases that I have seen, the default is front to back, however. Pull up the printer driver for your printer and look at all options. Sometimes options will make things seem pretty weird such as "BOOK" type duplex, printing in landscape mode, which will print (4) pages on one sheet of paper. On an (8) page report, pages 1 and 8 would print on the front side of sheet number 1, then pages 2 and 7 would print on the back side. On sheet number 2, pages 2 and 7 would print on the front and then 3 and 6 on the back.... and so on. This is so that the pages can be folded down the middle of the landscape print, stapled and create a book that reads pages 1 through 8 correctly. Also note that printing duplex can be tricky if you have different page length reports (or invoices in this case) If you have two (1) page invoices and have your printer set to duplex, they will both be printed on one page. The one invoice on the front and the second on the back. With most duplex printers, it will not matter that you created the two invoices in a loop and two print commands. The duplex function knows nothing about when to start a new invoice or not. You must control that with your program by using form feeds (new page after section) options, unless your printer driver has a "page feed between print job" option or ejects a page between print jobs by default. Hope that is of some assistance. -Bob ----- Original Message ----- From: Steve Breen <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Sunday, April 13, 2008 3:11 PM Subject: [RBASE-L] - RE: Duplex printing Issue - Rbase and Mayby not rbase By the way we are using a Rioch SP 8510 and a Rioch 4510 Printer -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Steve Breen Sent: Sunday, April 13, 2008 3:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Duplex printing Issue - Rbase and Mayby not rbase Here is my question What printers first when duplex printing? 1. The front page? 2. The back page? Here is my issue (and I can repeat this with Word and RBase): If I am tring to print a single page (1 sided document) all is ok. If it is a 2 sided invoice then the back page prints first and the front side second. This was is major issue since we are using single sided pre printed forms. In our case all the invoice information is on the front and then there are case notes and tire installation information that in some cases carry over on the back. Thes invoices are run ussing the following code. Each invoice is generated seperatly in a while loop. So as long as the invoice is one sided all is ok. When a two page (sided) invoice is generated it prints back page on the letter Head or Preprinted invoice side first and then front on the blank side. On the next invoice if only one page all is ok. Any Ideas. Help I am in a real bind on this one and under a time line. Thanks Stephen Breen CDI Services, Inc. Road Support Division -- new_INVPRINT.RMD -- Print invoices for a specified billing date -- This prints all invoices for all customers for the specified date, -- in invoice number order based on parmets set up RUN myset_off -- RUN myset -- start of code DIALOG 'Do You Want To Select A Invoice Number Range To Print By ...' vresponse1 vendkey1 no + CAPTION 'Invoice Selection Option ...' + ICON attention + OPTION BUTTON_YES_CAPTION YES + |BUTTON_NO_CAPTION NO + |OPTION MESSAGE_FONT_NAME ARIAL FB|MESSAGE_FONT_SIZE 12 IF vresponse1 = yes THEN GOTO invoice_range ENDIF IF vresponse1 = no THEN GOTO start_print ENDIF LABEL invoice_range RUN new_Get_Invoice2.rmd IF vinvoice1 OR vinvoice2 IS NULL THEN -- RUN errmsg.rmd USING 'No Invoice Number Entered' GOTO finish ENDIF DELETE ROWS FROM attinv_master_cust WHERE cdiinv < .vinvoice1 OR cdiinv > .vinvoice2 DELETE ROWS FROM attinv_charge_desc WHERE cdiinv < .vinvoice1 OR cdiinv > .vinvoice2 -- end of code LABEL start_print -- START OF CODE FOR TWO PAGE INVOICES -- CURRENTLY ONLY TRANSADVANTAGE NEEDS TWO PAGE INVOICES DROP CURSOR c1 DECLARE c1 CURSOR FOR SELECT pon FROM attinv_master_cust + WHERE (parentcustid = 164 OR parentcustid = 110 OR parentcustid = 193) + ORDER BY cdiinv pon OPEN c1 WHILE (1=1) THEN FETCH c1 INTO vpon IND i1 IF SQLCODE <> 0 THEN BREAK ENDIF PRINT new_invoice2 WHERE pon = .vpon + OPTION PRINTER + |DUPLEX horizontal + |COPIES 1 + -- using default printer here ENDWHILE -- END OF TRANSADVANTAGE 1ST PAGE PRINTING CODE -- START OF CODE -- RUN INV_PRINT_ATTENTION.rmd -- DIALOG box -- (CHAR(009)) = Tab Key (Indent) -- (CHAR(013)) = Carriage Return CLS SET VAR vmsg = + ('The First or Customer Copies Of The TransAdvantage Invoices Have Printed'+(CHAR(013))+ + ''+(CHAR(013))+ + 'Do You Wish To Print The Second or Payment Copy at this Time ??'+(CHAR(013))+ + ''+(CHAR(013))+ + 'If Printing Second Copy - Remove First Copy From Printer Now - Then Click Yes '+(CHAR(013))+ + ''+(CHAR(013))+ + 'Otherwise Still Remove Copies From Printer Now Before Printing Other Customer Invoices'+(CHAR(013))+ + ' Then Click NO or Press Enter'++(CHAR(013))) DIALOG .vmsg vresponse2 vendkey2 no + CAPTION ' INVOICE PRINTING ATTENTION NOTIFICATON ...' + ICON question + OPTION TITLE_FONT_COLOR BLACK + |TITLE_FONT_NAME ARIAL + |TITLE_FONT_SIZE 12 + |TITLE_BOLD ON + |TITLE_BACK_COLOR WHITE + |TRANSPARENCY 255 + |WINDOW_BACK_COLOR WHITE + |BUTTON_YES_CAPTION &YES + |BUTTON_NO_CAPTION &NO + |BUTTON_YES_COLOR GREEN + |BUTTON_NO_COLOR RED + |BUTTON_YES_FONT_COLOR WHITE + |BUTTON_NO_FONT_COLOR WHITE + |TOP 250 + |LEFT 200 IF vresponse2 = yes THEN GOTO start_print2 ENDIF IF vresponse2 = no THEN GOTO trans_printing_done ENDIF -- END OF CODE LABEL start_print2 -- START OF CODE FOR TWO PAGE INVOICES -- CURRENTLY ONLY TRANSADVANTAGE NEEDS TWO PAGE INVOICES DROP CURSOR c1 DECLARE c1 CURSOR FOR SELECT pon FROM attinv_master_cust + WHERE (parentcustid = 164 OR parentcustid = 110 OR parentcustid = 193) + ORDER BY cdiinv pon OPEN c1 WHILE (1=1) THEN FETCH c1 INTO vpon IND i1 IF SQLCODE <> 0 THEN BREAK ENDIF PRINT new_invoice2 WHERE pon = .vpon + OPTION PRINTER + |DUPLEX horizontal + |COPIES 1 + -- using default printer here ENDWHILE -- END OF TWO PAGE CODE CLS PAUSE 2 USING 'THE 2ND COPY OF TRANSADVANTAGE INVOICES HAS PRINTED - PLEASE REMOVE FROM PRINTER' + CAPTION 'INVOICE ACTION REQUEST - PRESS ENTER OR OK TO PRINTING NON-TRANSADVANTAGE INVOICES' ICON attention CLS LABEL trans_printing_done -- START OF CODE FOR SINGLE PAGE INVOICES -- CURRENTLY ONLY TRANSADVANTAGE NEEDS TWO PAGE INVOICES DROP CURSOR c1 DECLARE c1 CURSOR FOR SELECT pon FROM attinv_master_cust + WHERE (parentcustid NE 164 AND parentcustid NE 110 AND parentcustid NE 193) + ORDER BY cdiinv pon OPEN c1 WHILE (1=1) THEN FETCH c1 INTO vpon IND i1 IF SQLCODE <> 0 THEN BREAK ENDIF PRINT new_invoice2 WHERE pon = .vpon + OPTION PRINTER + |DUPLEX horizontal + |COPIES 1 + -- using default printer here ENDWHILE -- END OF SINGLE PAGE CODE CLS PAUSE 2 USING 'ALL INVOICES HAVE FINISHED PRINTING - PLEASE REMOVE FROM PRINTER' + CAPTION 'INVOICE ACTION REQUEST - PRESS ENTER OR OK TO FINISH' ICON attention LABEL finish DROP CURSOR c1 RETURN _____ No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1375 - Release Date: 4/12/2008 11:32 AM _____ No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.13/1375 - Release Date: 4/12/2008 11:32 AM
