thanks for quick response basker, they are able to access those two subject areas and the sample report from those two subject areas in the same folder. however after adding logical SQL by joining those two subject areas, they are not seeing results in report. me and others are able to view the results without any issue.…

no, we wanted to get the all employees current assignment statuses - for few employees, the current status is inactive..