Crystal Report only to print even number of pages 1

[fergusons]

I am trying to get a report to always finish on an even number of pages to allow double-sided printing and ensure that multiple reports do not overlap on the same sheet.

Any ideas ?

 

[lupins46]

Add a report footer which has a 'New Page Before' set.
Then in the Suppress conditional button for the report footer put:
pagenumber mod 2 = 0

This conditional formula is logically back to front to me, but it works this way round. (The mod operator gives the result after division by the number which follows it - a 2 in this case)

 

[fergusons]

The mod operator does not appear to work but thsi may be down to the version of Crystal I am running which is version 7.0

 

[lupins46]

If there's no mod then the equivalent expression is:
(Just hoping you can use the \ in v7)

(pagenumber\2)*2 = pagenumber

 

[fergusons]

Sorry but it does not like this either as when I try to save this formula it tell me I have a missing parenthesis before the '\'

 

[IdoMillet]

The function call is REMAINDER()

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[chelseatech]

To Expand on Ido's brief comment ... use
Remainder(PageNumber,2)=0

Use this in a conditional New Page After in an empty Group Footer section.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm