Reset record number on change of group

[menuch]

How can I reset the record number on change of a group?

Thanks!

Menuch

 

[pgtek]

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.

cheers

pgtek

 

[Madawc]

If you use a Running Total, that has an option to start afresh on each group.

Alternatively, you could add an invsible field to clear a variable in the group header.

Madawc Williams
East Anglia, Great Britain