Databases Reference
In-Depth Information
Figure 5-4.
The report page type
3.
In the next step, choose the Interactive Report type.
4.
Skip through all the steps in the wizard until you reach the step that allows you
to specify the SQL statement for the report. When you reach this step, specify
the SQL shown in Listing 5-3.
Listing 5-3.
Specifying the SQL for the Interactive Report
SELECT e1.EmpName, e1.EmpTitle, e1.EmpDepartment, e2.LeaveDate, e2.LeaveType, e2.LeaveReason,
e2.LeaveID FROM Employees e1 LEFT JOIN EmpLeave e2 ON e1.EmpID=e2.EmpID
5.
In the same step, select Unique Column for the Uniquely Identify Rows by
field, and LeaveID for the Unique Column field. You should now have the
screen shown in Figure 5-5. Click Next to continue.
