I added the Primary Bin to the Raw Materials subreport; however the PartBin.OnHandQty field picks up the first bin it finds, not the primary bin. I created a calculated field Calc_QOH =iif((Fields!PrimBin.Value = Fields!BinNum.Value), Fields!OnHandQty.Value, Fields!OnHandQty.Value) in the subreport properties, but I really want to just end the the statement once it matches the primary bin to the BinNum field and pull the quantity in that bin. Right now, the formula reports the total on hand for all bins and I do not have a valid second argument for the IIF statement. probably making this far more difficult than it needs to be… any help, really appreciate it 