Solved

Page on Group and Resetting Page Numbers

Posted on 2011-03-16
7
349 Views
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?

TIA
0
Comment
Question by:Clif
  • 4
  • 3
7 Comments
 
LVL 10

Author Comment

by:Clif
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.
0
 
LVL 100

Expert Comment

by:mlmcc
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?

mlmcc
0
 
LVL 10

Author Comment

by:Clif
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)
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 100

Expert Comment

by:mlmcc
ID: 35150546
Groups start on a new page?

mlmcc
0
 
LVL 10

Author Comment

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

Accepted Solution

by:
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.  

mlmcc
0
 
LVL 10

Author Closing Comment

by:Clif
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.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

19 Experts available now in Live!

Get 1:1 Help Now