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

Removing Page Header on Duplex Printer

Status
Not open for further replies.

krickard21

Technical User
Nov 18, 2003
6
US
I have a report that I would like to remove the Page Header from everyother page for duplex printing. I have tried some sugguestions from other post and haven't been able to get it to work.

Thanks in advance.

Krickard
 
Format, Section.
Highlight Page Header.
Click the X+2 button to the right of Suppress.
Enter the following line in the editor:
Code:
pagenumber mod 2 = 0
Save and Close.
Test the Report.

This suppress the page header on even number pages.

~Brian
 
I wish I could tell you that worked, But it didn't.
 
Does it work in the Preview mode of the Crystal designer?

What version are you working with?

~Brian
 
No it doesn't work when I preview. I'm running V8.5
 
I just created another quick example and the formula correctly suppresses the Page Header on all the even numbered pages. I am not sure why it is not working for you.

You might try a variation of the formula.
Code:
Remainder(pagenumber,2) = 0

~Brian
 
I had already tried that one from another post. It doesn't work either.
 
Put the page number field in your page header. Does it track the page correctly?

If it doesn't, check to see if you have a "reset page number after" set for any of your bands?

Mike
 
Mike thanks! That was it. I had a new page after stuck in there somewhere. It works now thanks to both of you.

Krickard
 
I have a new problem that is related to this old thread. This report is grouped on departments. If the records selected for the department goes to a second page then it throws off the above formula of

Remainder(pagenumber,2) = 0

making the pages that I want the header to print, not print, and the ones I don't, print. Is there a way to limit the amount of records printed per page for the details section.
 
You can create a running total of records within a group {#cntwingrp} by using the running total editor. Select a recurring field, e.g., {table.id}, count, evaluate for each record, reset on change of group (Department).

Then you can go to the section expert (format->section)->details and either force a page break after a certain number of records by going to "New Page After" and entering a formula in the x+2 area:

{#cntwingrp} = 25 //substitute the number where you want the page break

Or, you could suppress records greater than a certain value, if you only want to show the first n records, by going to "Suppress" and in the x+2 area entering:

{#cntwingrp} > 25 //Substitute your number

You might get a better response if you explained the problem more specifically.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top