Hi Scott,

>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.

It's better to do as much of data processing as possible in preparing cusrsor for report and use Report Writer for data formating and simple calcualtions/totalling.

>
>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.

Be carefull with UDF's in Report Writer because in some bands they could be called multiple times at the same point even when you print report.