Hey Hello Guys Can anyone help me When i do something about query but not result found please give me the solution about that Thankyou i am waiting check in time and check out time i need total working hours.
i do this Query in my report but not exactly generate this report
Select
c.name as “Attendance Name:Data:150”,
(select employee_name from tabAttendance where name = c.name) as “Employee Name:Data:120”,
(select department from tabAttendance where name = c.name) as “Department:Data:120”,
(select check_in from tabAttendance where name = c.name) as “Check in Time:Data:50”,
(select check_out from tabAttendance where name = c.name) as “Check Out Time:Data:50”,
(select working_hours from tabEmployee where employee = c.name) as “Working Hours:Currency:80”
from tabAttendance as c