I am creating an employee evaluation report. The report is grouped by the employee's manager. Though all the employees in the detail record have the same manager, they have one of two different positions. Their manager fills out evaluations for each employee based on the responsibilities of their position. These evaluations are stored in two separate tables.
All of the tables used in the report are connected by the employee ID. I am able to display the employee name and ID fields in the detail record. However, when I pull values from one of the evaluation tables into the detail record, the employees who hold the other position disappear and vice versa. Is there a way to pull this off without creating a SQL view on the back end to combine the data?
All of the tables used in the report are connected by the employee ID. I am able to display the employee name and ID fields in the detail record. However, when I pull values from one of the evaluation tables into the detail record, the employees who hold the other position disappear and vice versa. Is there a way to pull this off without creating a SQL view on the back end to combine the data?