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?
Edited by: Art Schwalge on Oct 4, 2008 6:55 PM