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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I need to purposely Skip a page

Status
Not open for further replies.

LostCait

IS-IT--Management
Aug 10, 2001
13
US
I hope you can help me.
I have a report, with three different groups. On the header for the first group - by name -I have new page before, reset page # checked, and on it's footer it have new page after, reset page# checked. On the second group - by category, there are no conditions on the header, but on footer I have new page after, reset # checked. On the third group - it is the same as the second. I have a details section with a conditional on new page after, and reset page number. The report works and resets and counts pages just the way I want it. Now we are going to put in a duplex printer and I have to fix the report to take advantage of it. I created a global variable to count the page numbers (since we reset them often!) and that works, but how do I purposely tell the report that either based on a change in name or change of a certain type, to skip a page if the page is an even page? I want all new names to start on the odd page (front facing), and certain types to start printing on the odd page. The counter is in the page footer of the report to count when a page is printed.

I know it's a long question, but I wanted to make sure I gave all the details!
Thanks!
 
Here is how to determine if a page number is even:


if remainder(PageNumber,2) = 0

The remainder function devides the first argument by the second argument, discards the result and returns the remainder.

Use this in your VERY complicated report. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com
800-783-2269
 
I would try an extra GH1a, telling it to do a "new page before" when the page is even. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Thanks for your help!
I had a version of the remainder formula, it was the GH1a I am missing. I will try the easier formaula and the header and see how it goes. I'll let you know.

Yes, complication is my forte!
 
As we all know, priorities change quickly and being the only programmer onsite means mine change hourly!

I thank you both for your suggestions - I incorporated the second GH1 and put in the mod formula. It worked to a point - it didn't like the header being suppressed, so I made the smallest possible header. Now it works great! We are duplex printing and saving nearly a ream of paper a day!
My thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top