Dynamic Column in script report

Suman_Roy · February 12, 2024, 11:12pm

Hi All
I am creating a report which shows me date wise report of working hour for contract labour upon choosing a date range. how can dynamically add columns onto that.

output

How can we add dynamic number of columns as per the date range selected by the user

Thanks in advance

mangroliya · February 13, 2024, 7:20am

Hi,

I am suggesting you read the code of Salary Register. It has dynamics columns.

github.com

frappe/hrms/blob/develop/hrms/payroll/report/salary_register/salary_register.py

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


import frappe
from frappe import _
from frappe.utils import flt

import erpnext

salary_slip = frappe.qb.DocType("Salary Slip")
salary_detail = frappe.qb.DocType("Salary Detail")
salary_component = frappe.qb.DocType("Salary Component")


def execute(filters=None):
	if not filters:
		filters = {}

	currency = None

This file has been truncated. show original

Regard,

Divyesh M.