Not on a page break

[TEM3]

Using Crystal Reports 8.5:

I am summing catagories within a group. Since I have to zero out my counters in the group header, I need to have my initialization formula there.

Problem is that it occurs on a page break when the group extends to more than one page.

Of course I could opt not to print the Group Header on each page. Or, as I was able to do, keep the group together and hope that it is less than a page long.

However, I do remember logic that could be applied to a formula like: Not On A Page Break. But I cannot find the syntax/command.

Help please??

 

[synapsevampire]

Why does a page break have anything to do with a group total?

You can always use a manual sum in a formula such as:

sum({table.field},{table.group})

-k

 

[lbass]

In your initialization formula use:

whileprintingrecords;
numbervar subtot; //replace with your variable name

if not inrepeatedgroupheader then
subtot := 0;

-LB

 

[TEM3]

It is not a "group total". It is a counter formula that tracks days pending within a group - 30 days or less = "Pending"; more than 30 days = "Backlogged". I have to zero the counters between groups. But since this is done in the Group Header, it gets zeroed when the Group spans a page break. I only want the initialization (zero-ing) formula to execute on a change of Group, not on a page break.

 

[lbass]

My solution should work. You could probably have accomplished this using the running total expert though, instead of manual counters.

-LB