I am working on BIRT Reporting tool, I have 4 tables as EMP_ATTENDANCE, EMP_APPLY_LEAVE, EMP_EXCEPTION_DETAILS and EMPLOYEE.
The Employee Table is linked with all the remaining tables.
EMPLOYEE
--------------------------------------------------------------------------------------
ID | EMP_NAME | EMP_APPLY_LEAVE_ID | EMP_ATTENDANCE_ID |
------------------------------------------------------------------------------------------
EMP_EXCEPTION_DETAILS_ID |.....
--------------------------------------
This is Employee Table I have.
EMP_ATTENDANCE
------------------------------------------
ID | DATE |.......
---------------------------------------
This is Attendance Table I have.
EMP_APPLY_LEAVE_DATE
----------------------------------
ID | FROM_DATE | TO_DATE |......
-----------------------------------------
This is Apply leave table I have.
Like the above table Exception details table I have. having the columns ID, START_DATE, END_DATE.
By using the above Tables. I want to get the absentees list.
Absentees means ---> all the Employees list, NOT in attendance table,NOT in apply leave table, NOT in exception details table.
MY I/P are----> Staet Date , End Date
whether I give two Dates like 15/11/2010 and 16/10/2010
I should get all the Employees list, those are not attended between these dates, not applied leave between these two dates and those not having exception details between these two dates.
That means
----> attendance date not between our I/P
----> apply leave from_date, to_date not between these I/P
----> Exception start_date, end_date not between these I/P
This requirement on BIRT Reporting.
Can any one Please HELP me to get this.
regards,
-------------------
Dileep Kumar.
dil.ravurimca@gmail.com