Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I print new groups on odd pages? 1

Status
Not open for further replies.

NSMan

Technical User
Aug 26, 2004
72
US
I've got a report that is grouping on the first left character of a field. I've got a "New Page Before" on my group header. Each time the next group starts on an even page, I want to skip another page and so the beggining of each group is printing on an odd page. I've tried putting a formula in the "New Page Before" that uses the mod command on the page number, but the formula doesn't seem to have any effect. It gives me an extra page on every group.

val({@nspage}) mod 2 = 0 -- This is the formula I'm using.

I'm using Crystal 11.
 
Since you didn't post what's in {@nspage}, how can we help with that?

Try turning off the New Page Before chackbox, and use the formula in the X2 next to new page before:

remainder(pagenumber,2) = 0

-k
 
Sorry, I'd created a formula and set the @nspage to the pagenumber. That worked! I owe you big, I get to go to bed before tomorrow morning now, mucho gracias!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top