Thanks Doug - I'll give it a try.
>Hi Tracy.
>
>>The problem doesn't occur until the user previews the report and during preview, clicks on the pages of the detail band (if only one page then for example he/she clicks on page 1 over and over) to zoom in and zoom out. Everytime the detail page is refreshed the function is called and the value of totcomcash is doubled, tripled, and on and on.
>
>Have you tried using SET REPORTBEHAVIOR 90? That would eliminate the problem because the rendering is just done once rather than every time the user moves from page to page or zooms in and out. Of course, that might have other consequences (numeric fields may need to be resized to avoid displaying ****), but it might be something you want to plan on doing for the long run.
>
>Doug
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"