Page Breaks if group details span more than one page

Posted on 2005-03-22
Medium Priority
Last Modified: 2012-08-14
Hi All,

    I have a report developed in Crystal Report 10.0. It is basically used to print Invoices.

Normally my invoices run into two pages( 1st page for the item details and the 2nd page for the instructions). I use a duplex printer so that the invoice gets printed in a single page. (back and forth).

But now i have run into a problem. Some of the invoices contain item details which take more than one page to print (they run into two pages). Due to this insctruction gets printed on the 3rd page.

The problem here is i am printing invoices in bulk. So if my first invoice runs into 3 pages, the next invoice now starts from page 4 and since i am using duplex printing mode it prints on the backside of the instruction page of the first invoice.

Is there any way i could print a blank page after any invoice if it runs into more than 2 pages.

Hope i have made myself clear.

This thing is driving me crazy.
Any help would be appreciated.

Question by:kamalnegi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 19

Accepted Solution

GJParker earned 1000 total points
ID: 13609611
Create a 2nd details section and make the height of this equivalent to 1 page then go into the section expert and add a suppression formula to check if the pagenumber is odd or even

Remainder (PageNumber,2) = 0

Hope this helps


Author Comment

ID: 13611278

Thanks Gary,

But i have figured it out myself.
This is what i have done

I have created a 2nd details section (height could be anything) and then added the the following supression formula to check if the page is odd or even

PageNumber mod 2 =1

The only other thing to note here is that i have to check the "New Page Before" and the "New Page After" on this section to work.(otherwise it doesn't work)

LVL 19

Expert Comment

ID: 13611350
Yes it's teh same principle.

LVL 19

Expert Comment

ID: 13915900
The answer I provided is identical to the resolution and is such is a valid answer to the problem.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question