on 10-04-2008 5:54 PM
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
Answer is this is a mystery!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.