Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
  • 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

572 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