Even we struggled quite long to bring the basic output. Finally got the basic output without making the script report to Standard.
Created a Script report and kept Is Standard to “NO”
Configured columns like below
In the query/Script section returned the simple result
result = [{“quotation”: “Here is a message”, “ebitda”: “abc”}, {“quotation”: “Here is the quote”, “ebitda”: “cba”}]
for now client code section is like below. Ideally we should be able to configure filters also like columns
frappe.query_reports[‘Script Report Test’] = {
“filters”:
}
Nutshell we don’t need execute function. The query script section is the execute function by itself.
Hope this helps someone