Report builder issue (AUTO EMAIL)

rs115199789 · August 12, 2024, 8:58am

Hi, everyone

When i’m trying to setup auto email for - Monthly Attendance Sheet
It ask me to apply month and year filter however when i’m trying to select year it won;t give me the options.
ERPNext: v15.32.0 (HEAD)

Frappe Framework: v15.37.0 (HEAD)

Frappe HR: v15.25.2 (HEAD)

India Compliance: v15.12.1 (HEAD)

Frappe Insights: v2.2.4 (HEAD)

Payments: v0.0.1 (HEAD)
Hosted on Frappe Cloud

Thanks

NCP · August 12, 2024, 9:09am

You can’t set it because In the Monthly Attendance Sheet report, years is the dynamic filter so it doesn’t worked in the auto email report.

github.com

frappe/hrms/blob/develop/hrms/hr/report/monthly_attendance_sheet/monthly_attendance_sheet.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// License: GNU General Public License v3. See license.txt

frappe.query_reports["Monthly Attendance Sheet"] = {
	filters: [
		{
			fieldname: "month",
			label: __("Month"),
			fieldtype: "Select",
			reqd: 1,
			options: [
				{ value: 1, label: __("Jan") },
				{ value: 2, label: __("Feb") },
				{ value: 3, label: __("Mar") },
				{ value: 4, label: __("Apr") },
				{ value: 5, label: __("May") },
				{ value: 6, label: __("June") },
				{ value: 7, label: __("July") },
				{ value: 8, label: __("Aug") },
				{ value: 9, label: __("Sep") },

This file has been truncated. show original

rs115199789 · August 12, 2024, 10:09am

Okay
thanks

rs115199789 · August 12, 2024, 10:10am

Is there any other option if i wanted to show that sheet to any other user ?