refine report relations