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