Dan: Do not use the report page numbering variable, use your own page number variable and increment it at each page break (just like the old DOS days); in between reports, you can adjust the page number variable so it always starts on an odd page number. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dan Sent: Thursday, February 10, 2005 12:54 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Generating Extra pages in a report Ok... this is going to work, Thanks... although I don't see how to get the page numbers to not reset between print statements. Each section starts with page one. At 01:11 PM 2/10/2005, you wrote: >You might resort to a cursor, and print each section separately, while >retaining the page number >increases. This will increase the report printing time somewhat, I >suspect, but it should still be >tolerable. > >DECLARE c1 CURSOR FOR + > SELECT DISTINCT <section header PK> + > FROM <reporting table> >OPEN c1 >FETCH c1 INTO vReptSection >WHILE SQLCODE <> 100 THEN > PRINT <report name> WHERE <section> = .vReptSection > FETCH c1 INTO vReptSection >ENDWHILE >DROP CURSOR c1 > > >--- Dan <[EMAIL PROTECTED]> wrote: > > > Hi, > > I submitted this request on the 8th, but guess that was too late. I do > > need to find a work around and am open to suggestions. > > Dan > > > > At 11:28 AM 2/8/2005, you wrote: > > >Ok, > > > Guess I should go to RDCC and suggest an enhancement request. > > >Dan > > > > > > > > >At 08:55 AM 2/7/2005, you wrote: > > > > > >>>When setting breakpoints to "start a new page on pagebreak" is there a > > >>>way at present, (or should an enhancement request be made) to cause > all > > >>>new pages to start on an even number or odd number? > > >> > > >> When generating a 100 page report, duplexed, we would like all new > > >> categories to start on the right hand side of the book so that Tabbed > > >> pages may be inserted in between. Currently a new page may end up on > > >> the back side of the last catagory. > > >> > > >>Thanks, > > >>Dan > > >> > > >>Thanks, > > >> > > >>Dan > > >> > > >>Dan Champion > > >>Information Services > > >>Service Coordinator > > >>Vredevoogd Heating > > >>3047 Sangra SW > > >>Grandville, MI 49504 > > >>(616) 534-8271 x10 > > >>www.vredevoogd.com > > >>www.championsolutions.net > > > > > >Thanks, > > > > > >Dan > > > > > >Dan Champion > > >Information Services > > >Service Coordinator > > >Vredevoogd Heating > > >3047 Sangra SW > > >Grandville, MI 49504 > > >(616) 534-8271 x10 > > >www.vredevoogd.com > > >www.championsolutions.net > > > > Thanks, > > > > Dan > > > > Dan Champion > > Information Services > > Service Coordinator > > Vredevoogd Heating > > 3047 Sangra SW > > Grandville, MI 49504 > > (616) 534-8271 x10 > > www.vredevoogd.com > > www.championsolutions.net > > > > > > >===== >Albert Berry >Management Consultant >RR2 - 1252 Ponderosa Drive >Sparwood BC, V0B 2G2 >Canada >(250) 425-5806 >(250) 425-7259 >(708) 575-3952 (fax) >[EMAIL PROTECTED] Thanks, Dan Dan Champion Information Services Service Coordinator Vredevoogd Heating 3047 Sangra SW Grandville, MI 49504 (616) 534-8271 x10 www.vredevoogd.com www.championsolutions.net
