-- Before you print the report, in your command file SET VAR #PAGE INTEGER = 0 -- (or perhaps 1). -- After the whole report has been printed, CLEAR VAR #PAGE
--- Dan <[EMAIL PROTECTED]> wrote: > 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 > > ===== 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]
