How to reset an array counter on change of group

[menuch]

Is there any way of reseting an formula conataining an array on change of group to get the first record in each group in the Details section?

 

[putts]

Make a variable to keep track of the value that you're grouping by and then act accordingly.


Shared stringvar groupValue;

if {GroupNameValue} <> groupValue then
//run code here

groupValue := {GroupNameValue};

//blah blah blah

There may be a more official way to do it but that should work.

 

[Ngolem]

you would have an array pointer that would be reset in the group header....but you don't want it reset in a repeated Group header (ie. group splits over 2 pages) so put this in the Group header

@IntializePointer (Suppressed in group header)

NumberVar Pointer;

if not inRepeatedGroupHeader then
Pointer := 1;


Use pointer then when you reference your array and incriment it as you normally would.

Jim Broadbent