Skip to Content
Former Member
Oct 04, 2008 at 04:54 PM

Custom Function involving Left Outer Join


I have two tables, SalesTran and Product. They are joined by SalesTran.PrdID and Product.PrdID.

Sometimes a record in SalesTran has no PrdID. I have made a left outer join so that these SalesTran records are included in my report.

I have written a formula based partially on PrdID and used it for grouping.

All of this works correctly.

I converted my formula to a custom function so that I could copy it to the repository and use it in other similar reports. But I found that the custom function did not work properly.

I traced the problem to the fact that the tables are linked with a left outer join rather than an inner join. It seems that when PrdID and other arguments are passed to the function they are not evaluated in the context of a left outer join.

I tried calculating the values before passing them to the function, but this had no effect.

Has anyone encountered this type of problem and come up with a solution?

Thank you,


Edited by: Art Schwalge on Oct 4, 2008 6:55 PM