How to make report to get the total of working hours for emp

1

How to make report to get the total of working hours for emp like this

image
image2071×801 101 KB

2

iwant emp 1 worked 150 hours
emp 2 worked 160 hours etc

3

Hi @Mohamed_Hossam,

Please creata a Query Report for it.

SELECT 
    `tabAttendance`.`employee` AS `Employee:Link/Employee:150`,
    SUM(`tabAttendance`.`working_hours`) AS `Total Working Hours:Float:150`
FROM 
    `tabAttendance`
WHERE 
    `tabAttendance`.`status` = 'Present'
GROUP BY 
    `tabAttendance`.`employee`

Please check and verify the field name.
Then reload and check it.

I hope this helps.
Thank You!

4

thanks alot <3

5

@NCP Can you tell me how to add filters in the report for specific months cause it calculate all months

6

That for, you should develop the custom server script report.

Thank You!