I have a report where I am creating multiple joins. By the time I get to the third level there is no longer any data at all pulling through. Any thoughts on how to trouble shoot would be greatly appreciated. Structure is like below:
Joined Dept data = Audit changes + OrgLvl2Info
Joined Job data = Audit Changes + Job Info
Joined Supervisor data = Audit Changes + Supervisor Info
Joined final Supervisor data = Query data + Joined supervisor data (created above)
Everything hold data until the last one and it is blank. Thanks