cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Function involving Left Outer Join

Former Member
0 Kudos

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,

Art

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Answer is this is a mystery!