I have created a function that is stored in the DBC and need to use this function in a report. The function will calculate a rate but its parameters come from aggregate values calculated in a summary band. Due to this, the function call seems to be the only way to do this. The function will retrieve the rate from a view (an unrelated view used in the report).

However, the report just lists the same detail row over and over for the number of rows in the report view. It seems the report is not selecting the report view work area when the function returns and lists the first line.

Does anybody know what might be causing this?

Thanks in advance.

Bob F.