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 101

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)
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

LVL 101

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 101

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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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