Formula to 'Reset Page Number After' in a group
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8184
Printed Date: 03 May 2024 at 4:25pm
Topic: Formula to 'Reset Page Number After' in a group
Posted By: stormy267
Subject: Formula to 'Reset Page Number After' in a group
Date Posted: 31 Oct 2009 at 6:25pm
|
Hi...
I have a crystal report problem.... I have made a form that has lots of grouping by.... By Team Number, Family Number and Individual Number The scenario with my report was that one family can have multiple individual number and one team number can have multiple family. This form needs to be sent to the head of the family members (in this case the father or the mother (if no father in the family)) OR per family. But page break individual number (each invidual has their separate page) so in section expert on details section i checked on the new page after. group header 1 - team number group header 2 - family number group header 3 - individual number details group footer 3 - individual number group footer 2 - family number group footer 1 - team number I have put the 'page N of M' under group footer 2 - family number and checked on reset page number after. So if one family has 3 individual (father, mother and son) it should show page 1 of 3 on father's page, 2 of 3 on mother's page, 3 of 3 on son's page for that family. So the page N of M is grouping on family number level. I have put the 'Page N of M' under group footer 2 - family number but i keep on getting 1 of 1 for each individual page... how can i reset the page numbering starting new family name? Is there any formula (x+2) that i can put in group footer 2 - family number on 'reset page number after' to just reset page page number after for certain group in this case family number group? Please help. Thank you. 
|
Replies:
Posted By: DBlank
Date Posted: 01 Nov 2009 at 5:59pm
|
try moving your "page n of m" field to the page header or page footer and make the Reset page number on Group footer 1, not group footer 2
or on Group header 1 as a formula:
NOT onfirstrecord
|
Posted By: ponyo8
Date Posted: 04 Nov 2009 at 10:55am
| That still didnt work :( |
Posted By: DBlank
Date Posted: 04 Nov 2009 at 12:59pm
|
Hmm, I am having trouble visualizing how you want this to work. In your example you have father, mother and son.
based on your grouping, they all have there own "individual number" but they have the same 'Family Number' and the same 'Team Number', correct?
|