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

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
  • 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

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. …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

791 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