Group sum on second page is incorrect when repeating group header on each page
Group sum on second page is incorrect when repeating group header on each page
(OP)
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:
in group 4 header I have:
and in the Group 2a footer:
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.
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.
RE: Group sum on second page is incorrect when repeating group header on each page
-LB
RE: Group sum on second page is incorrect when repeating group header on each page
Just for my own education, can you explain a bit why that works as opposed to my original set up?
RE: Group sum on second page is incorrect when repeating group header on each page
-LB
RE: Group sum on second page is incorrect when repeating group header on each page
Thanks again. I appreciate it.