This sounds doable, but Alberts suggestion is already up and running, and I think it will work well. It does however take a little longer to run than my original print statement.
Excellent suggestion however, I might tinker with it just so that I can learn something new and maybe use it again sometime.
Thanks Larry.
Dan
At 03:08 PM 2/10/2005, you wrote:
> 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.
This suggests a possible single-pass solution to the problem.
The idea is that put something in your break footer (the break that you want to
force an odd or even page) that will expand to push the report to a new page,
but only when you have an odd or even (whichever you want) page number.
You could do this as follows:
1. In the report header, create a variable
rvLotsOLines = (SFIL(CHAR(10), 75))
2. Set up manual control of the page variable as described by Javier so that the page number is in the variable rvPageNo
3. In the break footer, create a variable
rvSlug = (IFEQ(MOD(.rvPageNo, 2), 0, NULL, .rvLotsOLines))
(a slug, by the way, is a piece of lead used to space lines of text when
manually setting type -- which is exactly what this variable is going to do for
us).
4. In the break footer, place a Variable Memo control. Set it to STRETCH and the variable should be rvSlug.
Now, when a break footer is evaluated, if the page number is even, enough space
will be emitted in the footer to force the next break header to be on an odd
page. (If you want the headers to be on even pages, not odd, just change the
second term of the IFEQ function from 0 to 1).
You may need to play around with just how big the slug is (you want enough
space to always force the break footer to go onto the next page, even if you
are still at the top of the page when the break footer start, but NOT so much
space that you run the risk of flowing on to two pages). You can do this by
raising and lowering the number 75 in the rvLotsOLines variable, or by changing
the font size of the memo control.
--
Larry
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
