A while back there was a post that showed a workaround for Reporter to create running totals that would reset at group breaks. This is the post

http://www.revelation.com/8525656100571cbb/e4a32622500660198525631900091149/97E1EC0342D6AB6E852567B300501D93?OpenDocument

I have used a variation of this successfully until I became aware that the running total will never reset if the selection criteria happens to result in only one group. Each successive print preview or printing will continue to accumulate totals from the last. The problem of course is that, in the example code, COMP_PREV is always the same as COMP_CURR.

How can I create a calculated field that will null COMP_PREV only once at the beginning of the report? I have tried by putting a calc field in the report header, group footer, report footer, etc. In each case, the running total is reset after every record, so it is no longer a running total. I need to accomplish this within Reporter, not before or after it is called.

(Of course a preferred alternative would be to tell me how SumCond works so that I would not need a workaround.)

Thanks for any help

Andrew,

Contained within the web posting thread you mentioned, are all known

recommendations and alternatives for the function that you are trying to perform.

View this thread on the Works forum...