?
Solved

Add new page after group in crystal reports

Posted on 2013-01-19
4
Medium Priority
?
7,890 Views
Last Modified: 2013-01-20
I have a crystal report that I am trying to print on both sides if there are enough records in the group. Here's what I have

Report Header

Page Header

Group Header Section

Section Details

Group Footer

Report Footer

Page Footer

What I want to do is if the group doesn't have enough records to fill and a page front and back then add a blank page.

Example: Say the group has 20 records and I can get 50 records on a page. Then after the 20 records I need to add 2 new pages. One for the end of the group and one so that the next group doesn't print on the back of the current group.
0
Comment
Question by:whiwex
[X]
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
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Deepak Lakkad
ID: 38797803
Hi,

As I understand, you want to print your new group on new page even if the page is empty.

If so, you can use Group Footer's property. The steps are as below:

1. Right click on group footer
2. Select "Format Section..."
3. Check "New Page After" check box.
4. Press Ok.

- Deepak Lakkad
0
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 38798018
To do this you need 2 group footer sections. You have one already (which i assume is set to throw a new page after) so you need to add another one - right click in the left section label  for group footer and choose Insert Section Below.
You can make this as small you like.

For the new group footer section, in the NewPageAfter conditional format button you use...

PageNumber mod 2 = 1

This will throw an extra new page if the group footer is on an odd numbered page.
0
 

Author Closing Comment

by:whiwex
ID: 38798718
After a week of struggling with this I finally figured it out. I'll give you credit anyway because your answer is almost correct. You have to have the second group but you also have to have something in the groupfooters. I mde the group footers as small as I could without putting anything in the footer. It now works
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38798738
"You have to have the second group but you also have to have something in the groupfooters"

I haven't found this to be the case myself.

Just to be precise, I did not say you need another group, only a second group footer for the existing group.
Capture15.PNG
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

741 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