Script Report

Mute Footer Text

$('.report-footer.text-muted').hide();

Before Text Mute

After Text Mute

Usage

frappe.query_reports["Test"] = {	
	"filters": [],
	"onload": function(report) {
			setTimeout(function() {
            	$('.report-footer.text-muted').hide();
            }, 1000);
		});
	}
};

Remove Column on Report Datatable

frappe.query_report.datatable.removeColumn()

Remove column by index

Usage

frappe.query_reports["Test"] = {	
	"filters": [],
	"onload": function(report) {},
	"after_datatable_render": table_instance => {
        frappe.query_report.datatable.removeColumn(0)        
    }
};

The index '0' column will not appear in the report view, but it will be included when exporting to Excel

Remove column by fieldname

Usage

frappe.query_reports["Test"] = {	
	"filters": [],
	"onload": function(report) {},
	"after_datatable_render": (table_instance) => {
        let columns = table_instance.datamanager.columns;
        columns.forEach((col) => {
            if (col.fieldname === "employee_name") {
                table_instance.removeColumn(col.colIndex);
            }
        });
    }
};

The Employee Name column will not appear in the report view, but it will be included when exporting to Excel

Add content after the report title

reportTitle.after()

Usage

frappe.query_reports["Test"] = {
	"filters": [],
	"onload": function(report) {
		$(document).ready(function() {
			let reportTitle = $(".page-title");
			let additionalContent = $("<p style='color:#975a16;'><br>This is additional content after the report title.</p>");
			reportTitle.after(additionalContent);
		});
	}
};

Show Dummy Code: Dummy Name in Dummy Code Column

frappe.utils.get_form_link()

Usage

frappe.query_reports["Test"] = {
    "filters": [],
    "onload": function(report) {},
    "formatter": function (value, row, column, data, default_formatter) {
        value = default_formatter(value, row, column, data);
        if (data) {
            value = frappe.utils.get_form_link(
                "Dummy", data.dummy_code, 1, `<span style="font-weight: bold">${data.dummy_code} : ${data.dummy_name}</span>`
            )
        }
        return value
    }
}