At 02:00 PM 2/10/2005, you wrote:
-- 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]
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
