@tmayfield and I found that there was a row in OrderHed_ for each ship dtl line so when joined back to ShipDtl on OrderNum, you’d get 1:M and thus end up with the Summed result that Tammy was questioning.
For now, given they only print one pack at a time and only put one order on a pack, we just made another dataset and queried OrderHed_ and Tammy was happy with First(field,“OrderHed”).
Alternatively Tammy, we could have made a field in the main dataset as (SELECT MIN(OrderHed.AddtlShipContactName_c) FrOM OrderHed_" + Parameters!TableGuid.Value + “) as [Contact Name], (SELECT MIN(OrderHed.AddtlShipPhoneNum_c) FrOM OrderHed_” + Parameters!TableGuid.Value + ") as [addlPhoneNum] and so on and so forth and then you just need to add those fields to your main dataset.
We also talked about using a subquery as well and grouping by all the fields in OrderHed table and then joining that subquery to ShipDtl in the main query.
Many things we could do.