Print Page | Close Window

Page Breaks for Duplex Printing of a form letter

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11176
Printed Date: 03 May 2024 at 11:25am


Topic: Page Breaks for Duplex Printing of a form letter
Posted By: BenKason
Subject: Page Breaks for Duplex Printing of a form letter
Date Posted: 22 Sep 2010 at 8:49am
I have a very simple report that just pulls data for some letters.
I have a grouping in it that groups together and inserts a page break after the group.

The Problem is I want to do duplex printing, so when it runs the group onto two pages it will print duplex, which works now, but when the group only fits one page I need to generate a blank page after it so that the duplexing doesn't screw up, and print the next record on the back side of the page.

any ideas how I can get that blank page to generate, but only when the grouping fits on only one page?
I also would want to suppress my page header and footer on that second page always.

I can't figure it out for the life of me. I thought I could put in a new group footer to generate another page break, but then that screws up all the records after one rolls onto two pages.

Please help if you can.
Thanks


Replies:
Posted By: DBlank
Date Posted: 22 Sep 2010 at 9:13am
is this what you are looking for:
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=6302 - http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=6302

Posted By: BenKason
Date Posted: 22 Sep 2010 at 9:21am
I found that article, yes, however the PageNumber MOD 2 = 1 variable doesn't work for me.
I have followed the steps in that document to the letter.

I used the PageNumber MOD 2 = 0 variable to suppress the contents of my Page Header and Page Footer fields, however I used that right on the field itself.

I just cannot get it to create the new blank page after the grouping.

Posted By: DBlank
Date Posted: 22 Sep 2010 at 9:40am

1. how many group levels do you have?

2. where did you place the  pageNumber Mod 2 = 1 formula?

Posted By: DBlank
Date Posted: 22 Sep 2010 at 9:41am
3. do you ever have an instance where you want to have more than 1 group of data on the 'front' page?

Posted By: BenKason
Date Posted: 22 Sep 2010 at 9:52am
I only have one Group in the entire report. It is a dead simple report.
report header - no formatting
page header - I have suppressed the object in this section with PageNumber MOD 2 = 0 - THIS WORKS!

group header - In the Section Expert for this field I have put in Not onfirstrecord for the 'New Page Before' section - The check box is NOT checked. Keep together is checked as well.

detail - No Formatting
group footer - In the Section Expert for this field I have put in PageNumber Mod 2 = 1 for the 'New Page After' section - The check box is NOT checked. Keep together is checked as well
page footer - I have suppressed the object in this section with PageNumber MOD 2 = 0 - THIS WORKS!
report footer - No formatting

Posted By: DBlank
Date Posted: 22 Sep 2010 at 10:01am
you do not have to check the 'keep together' in either header or footer.
 
Check all sections and make sure you do not have the Reset page number after marked as TRUE anywhere.
 
You can do further testing by
1. place the page number field (special fields) on the report footer or header to make sure it is doing wat you expect
2. creating a formlua field called "Test_Page_Break" as
PageNumber MOD 2 = 1
and place in the group footer. You should see it say TRUE on ODD pages and FALSE on even pages
Is this all correct?

Posted By: BenKason
Date Posted: 22 Sep 2010 at 10:22am
I have removed the Keep Together Check Boxes
I put the Page Number on the page header and it displays accurate numbers
No Reset Page Number is selected
The formula displays True and False accurately.
The Page Number displays the correct page number.

I'm so confused... :)

Posted By: DBlank
Date Posted: 22 Sep 2010 at 10:26am
try and make the check boxes as true (checked) in next to the formulas field in the new page before/new page after...

Posted By: BenKason
Date Posted: 22 Sep 2010 at 11:44am
That has no impact, I've tried with them both ways.

Posted By: DBlank
Date Posted: 22 Sep 2010 at 11:46am
take the formulas out and mark them the boxes as  true.
are you getting page breaks all the time?

Posted By: BenKason
Date Posted: 22 Sep 2010 at 12:24pm
Well the group is on the next page but there is no blank page inserted at all.

Posted By: BenKason
Date Posted: 22 Sep 2010 at 1:04pm
I think I may have figured this out...

I created a second Group footer with a blank text field in it. For this section in the Section Expert, I checked the "New Page Before" option. Then in the formula box to the right of "suppress" I entered this formula:

(Remainder(pagenumber,2)=1)


This got me my blank page at the end of the group. This section is suppressed though if there are an even number of pages though so you don't get the blank page.

Seems to have worked. It gives me a couple of empty pages at the end of the report that I need to figure out , but seems good so far.


Print Page | Close Window