Dan
I'm sure it could be done programatically, but I'll need a hand from others
in the list to fill in one missing detail.
Let's say your report breaks on Category
Instead, you write code like this
DROP CURSOR C1
DECLARE CURSOR C1 FOR SELECT DISTINCT Category from tablename (+ where
clause to limit rows if needed)
OPEN 1
SET VAR vCategory TEXT = NULL
SET VAR vI1 INTEGER = NULL
WHILE #PI <> 0 THEN
FETCH C1 INTO vCategory IND vI1
IF SQLCODE = 100 THEN
BREAK
ENDIF
-- Now I need help from the list: Long time ago there was a method
allowing
-- you to set the starting page number for a report each time you
reprinted
-- but I can't find my notes on this and how it works in RBase 7.x
-- The idea would be:
-- 1st category, page number = 1
-- At end of each category, check last page number printed
-- If it's an even number, set starting page number = (last page number +
1)
-- If it's an odd number, set starting page numebe = (last page number +
2)
PRINT reportname WHERE Category = .vCategory
ENDWHILE
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message -----
From: "Dan" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Monday, February 07, 2005 1:03 PM
Subject: [RBG7-L] - Re: Generating Extra pages in a report
> Anyone?
>
>
> 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
>
>
