Solved

Add new page after group in crystal reports

Posted on 2013-01-19
4
6,682 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
  • 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

864 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now