# Report Builder - Part, PartBin, PartTran **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2000-08-29 10:23 UTC **Views:** 357 **Replies:** 0 **URL:** https://www.epiusers.help/t/report-builder-part-partbin-parttran/945 --- ## Post #1 by @system
I need to write a report which shows Part#, Description, LastMtlCost, OnHandQty, Calculation of LMC*OHQ, then also total stock transactions for 1998,1999,and 2000 which I use TranDate and TranQty and TranType begins "stk" from PartTran in the filters and formulas. I have been using tables: Part, PartBin, PartTran. The problem is that no matter what order I try to join the tables, as soon as PartTran and PartBin are both joined, it distorts my OnHandQty total. I've tried grouping by the Part# in Part and in PartBin depending on the join sequence. I've created hundreds of Report Builder reports so I am familiar with it. Hopefully I'm just overlooking something. If you can offer any help at all, please e-mail or call 219-264-2190.
Thanks in advance!! Ann Harrell


[Non-text portions of this message have been removed]
--- **Canonical:** https://www.epiusers.help/t/report-builder-part-partbin-parttran/945 **Original content:** https://www.epiusers.help/t/report-builder-part-partbin-parttran/945