Page on Group and Resetting Page Numbers

Posted on 2011-03-16
Last Modified: 2012-05-11
I have a report that has two groups.  I want to be able to start a new page when group 1 changes, as well as have the page number reset.  In the Section Expert of Group 1 heading, I check "New Page Before" and "Reset Page Number After".  I have "Page n or m" in the Page Footer.

The result is...
Page 1 only contains the report header.  No page number at the bottom.
Page 2 starts with the first group item.  Page number at the bottom says "Page 2 of 2"
Page 3 starts with the second group item.  Page number says "Page 1 of 1"
Page 4 starts with the third group item.  Page number says "Page 1 of 1"
Page 5 continues the third group item.  Page number says "Page 1 of 2"

And so on...

Two part question...
1. How do I get the first group item on the first page?
2. How do I reset the page numbers correctly?

Question by:Clif
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
  • 4
  • 3
LVL 10

Author Comment

ID: 35150211
Sorry, I accidentally had "New Page After" checked.

This fixes the blank (heading only) first page problem.

However, it does not fix the page number problem.  That is still an issue.  It seems that, whenever a group will span multiple pages, the first page of the goup will say "Page 1 of 1" and the second (continuing) page of the group will say "Page 1 of x" where x is the number of pages in that group.
LVL 100

Expert Comment

ID: 35150362
If you go back to the first page of the group does it reflect 1 of 2?

Are you repeating the group header on each page?

LVL 10

Author Comment

ID: 35150409
Going back and forth does not alter the page numbers (if that is what you're asking).

The group header only appears on the first page for the group (of both those groups that are single page and those that span multiple pages)
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 100

Expert Comment

ID: 35150546
Groups start on a new page?

LVL 10

Author Comment

ID: 35150620
Yes.  That is what I wanted and that part works.  The problem is that the page numbers seem to lag.
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 35151402
I was just trying to ensure that the 1 of 1 wasn't from the group starting on the page with the report header.

Figured it out.  I modified one of my reports to have multiple groups and a long  enough range to have multiple pages.

Group Header - You can do the NEW PAGE BEORE here or NEW PAGE AFTER on the GROUP FOOTER

Reset Page Number After - set this on the group footer.  Otherwise it resets the page number after the group header.  

LVL 10

Author Closing Comment

ID: 35151969
The ultimate solution was to use the New Page After on the group footer and Reset Page After also on Group Footer.

Thanks for your help.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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 …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

696 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