specific join for reportlist