Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group sum on second page is incorrect when repeating group header on each page 1

Status
Not open for further replies.
NBVC

NBVC

Technical User
Sep 18, 2006
80
CA
I have a report with a group header that I want to repeat on each page (Group 2a) - GH1 is suppressed.

I went to the Group Expert and indicated to repeat on each page.

But now when the group extends to a second page the summary I had on the group footer only sums the values for the second page and doesn't include the values from the first page.

If I don't repeat the group header, then it sums correctly on the second page.

I have a "whileprinting" formula in the group 2a header:

Code: 
WhilePrintingRecords;
Global NumberVar MyTotal := 0;

in group 4 header I have:

Code: 
WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal := MyTotal + {@PlannedJobReq};

and in the Group 2a footer:

Code: 
WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal

what do I need to do to be able to repeat the group header on each page and at the same time give me the correct sum for all values when extending to more than one page.
 
Sort by date Sort by votes
Add another GF section--GF2b that is set to suppress blank section and then move your reset formula from GH2 to GF2b and suppress it.

-LB
 
Upvote 0 Downvote
Thanks very much again for your help LB. It seems to have worked.

Just for my own education, can you explain a bit why that works as opposed to my original set up?
 
Upvote 0 Downvote
The reset formula in GH2a was resetting on every page because it was repeating on each page.

-LB
 
Upvote 0 Downvote
Ok. That makes sense.

Thanks again. I appreciate it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
405
bbranco
bbranco
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
574
SarahSCPDAdmin
SarahSCPDAdmin
G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
164
george1610
G
NBVC
  • Locked
  • Question
Group header on second page not printing when sending to printer, but ok in preview.
Replies
0
Views
204
NBVC
NBVC
H
  • Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
187
DjangMan
DjangMan

Part and Inventory Search

Sponsor

Back
Top