Please help me, I want to add the NeedByDate field in the Report

Have you tried with the Transfer Order Number as a relationship join as well? I dont think Company and Part Num will work on their own as there could be potentially many outcomes.