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]
