Is there something else that can be used as a key identifier, like WarehouseID, that would be common to both reports? Can you redesign one report or the other so they have compatible data? If not, then I really can't see how it could be done.