Need expense claim report with filter month and year

[satyamsathya978]

Hi All,
I need expense claim report with filters Month and Year

Thanks in Advance

[NCP]

You can set filter like

Otherwise, make a server script report according to the requirement.

[Edit]
Also, check the your previous post reference

I need "from date" and "to date" filter in query report

Please apply the query: SELECT ta.employee AS "Employee:Link/Employee:200", COUNT(CASE WHEN ta.status = 'Present' THEN 1 END) AS "Total Present:Int:200", COUNT(CASE WHEN ta.status = 'Absent' THEN 1 END) AS "Total Absent:Int:200", COUNT(CASE WHEN ta.late_entry = 1 THEN 1 END) AS "Total Late Entry:Int:200", COUNT(CASE WHEN ta.early_exit = 1 THEN 1 END) AS "Total Early Exit:Int:200", SUM(TIMESTAMPDIFF(HOUR, ta.in_time, ta.out_time)) AS "Total Working Hours:Float:200" FROM …