How to make script report with color format

[Alaa_Badri]

How to make script report with color format

[cpurbaugh]

You’ll have to be more specific than that.

[Alaa_Badri]

Dear @cpurbaugh
i made query report for quotation doc but it’s not possible to change it’s format so i need to know how to make script report with the same function but with colored column background and etc…

[clarkej]

[Tutorial] Add Color to Cells in Query Report

We can add color to cells in report based on cell value. Here we have made cells in row green if Rental Payment greater than 100 else red. add following code to query_report_name.js file frappe.query_reports["Payments Received"] = { "filters": [ { "fieldname":"customer", "label": __("Customer"), "fieldtype": "Link", "options": "Customer", "width": "80" } ], "formatter":function (row, cell, value, columnDef…