Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Formula to 'Reset Page Number After' in a group Post Reply Post New Topic
Author Message
stormy267
Newbie
Newbie


Joined: 31 Oct 2009
Location: United States
Online Status: Offline
Posts: 1
Quote stormy267 Replybullet Topic: Formula to 'Reset Page Number After' in a group
    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.

Edited by stormy267 - 31 Oct 2009 at 6:26pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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


Edited by DBlank - 01 Nov 2009 at 6:01pm
IP IP Logged
ponyo8
Newbie
Newbie


Joined: 31 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote ponyo8 Replybullet Posted: 04 Nov 2009 at 10:55am
That still didnt work :(
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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?
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.