Author Topic: Trying to create 6+ joins  (Read 121 times)

Offline stephanie.ellis1

  • Associate
  • **
  • Join Date: Sep 2018
  • Posts: 2
  • Forum Citizenship: +0/-0
Trying to create 6+ joins
« on: 14 Sep 2018 10:00:05 am »
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