Hi Sergey:
I suppose so. It rankles me that what is a relatively straight forward multi-level report without using the report designer is very messy when using it. It has become a case of the tail wagging the dog if I want to replicate the old report. In as much as maintainability of code is high on my prioirties I'm thinking of dumbing down the report to a level the report designer can handle without me having to stand the program on it's head.
In this case it seems to be a case of how can I keep a UDF called on each line item from executing every time the line is displayed while previewing the report. Without setting all sorts of switches and comparing previous to current report control breaks I don't see any way to do this.
Thanks for the feedback,
Scott
Scott Ramey
BDS Software