Likely your Report entity has no association to the Order entity, because logically there is not any relation between the two.
Rather then creating a XPath datasource, create a microflow datasource and in that microflow retrieve Order using $Report's dates like this: