There are a couple ways you could go about this. Try creating a group around the "Area" field and setting the DBCalc.ResetGroup to that group. If you leave the group header and footer at the minimum vertical size, you should not see any difference in your report output.
Another way would be to use a TppVariable and calculate the count manually based on the traversal while also keeping track of the Area field and reseting the variable accordingly.
Comments
There are a couple ways you could go about this. Try creating a group
around the "Area" field and setting the DBCalc.ResetGroup to that group. If
you leave the group header and footer at the minimum vertical size, you
should not see any difference in your report output.
Another way would be to use a TppVariable and calculate the count manually
based on the traversal while also keeping track of the Area field and
reseting the variable accordingly.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com