Running Totals Reset on Page Break 1

[EricNolan]

I have a running total for a formula field that is calculated in the detail section and displayed in the group footer. I have the reset formula in the group header, and when I choose the "Reprint Group Headings" option in the "Change Group" dialog, it is resetting the running total when my group runs over a page. Is there any way to maintain the running total while still printing the group header on each page.

I really have two groups that this applies to, and I can't put any "New Page" when the group changes because the report would get too long.

Thanks,

Eric

 

[lbass]

Change your reset formula to something like:

whileprintingrecords;
numbervar grpsub;

if not inrepeatedgroupheader then
grpsub := 0 else grpsub := grpsub;

If you used the running total editor instead of manual running totals, this would automatically be taken care of, i.e., without any special formulas to correct for repeated group headers.

-LB

 

[EricNolan]

Thanks lbass - that did it! I would have used the running total editor but the field I wanted to total were not available - is this because they are themselves calculated?

 

[lbass]

Some calculated fields (some formulas) will appear for use in the running total editor (generally if they calculate within each detail record), but summaries are not available or formulas which use functions like previous() or next(). The manual running total is the way to go if you are using summaries.

-LB