how do i add sohipline.trandesc to this report

SO, in this designer report the item line is not picking from the correct path that is SoShipLine.TranDesc. 

The Soshipline was not in it so i join it to the table of SoShipment. 

I try adding it but the result was duplicating itself on every line

this was the formual that was puling the item.

=IIf([SOPickerListEntry.LotSerialNbr]<>Null, Format('{0} {1} {2}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.LotSerialNbr],[SOPickerListEntry.InventoryID_description]), Format('{0} {1}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.InventoryID_description]))

This is after I join SoShipLine to get TranDesc 

this is the formula i used

=IIf(
    [SOPickerListEntry.LotSerialNbr]<>Null,
    Format(
        '{0} {1} {2} {3}',
        [SOPickerListEntry.InventoryID],
        [SOPickerListEntry.LotSerialNbr],
        [SOPickerListEntry.InventoryID_description],
        [SOShipLine.TranDesc]
    ),
    Format(
        '{0} {1} {2}',
        [SOPickerListEntry.InventoryID],
        [SOPickerListEntry.InventoryID_description],
        [SOShipLine.TranDesc]
    )
)
 

And this is the results

The last sentence of “CAST IRON WELL SEAL OFFEST **blue**’ “supposed to be on just the first line but you can see it on every line.

I need help please.?