Report scripts help

[wale]

@lasalesi

def execute(filters=None): columns, data = , columns = [“header”, “TRASN ID”, “TRANS DATE”, “OUTLET ID”] parents = frappe.db.sql(“<your query”, as_dict=1) for parent in parents: data.append([parent[‘name’], parent[‘trans_id’], parent[‘trans_date’], “”]) children = frappe.db.sql(“”, as_dict=1) for child in children: data.append([“detail”, child[‘item_code’], child[‘item_name’], “”]) return columns, data

Hi @lasalesi

Thanks for your great work on the forum. For the last couple of days we’ve been trying to figure out how to make custom Script Reports work… particularly for accounts hosted with Frappe where we don’t have Server/Admin access

So far, it appears to be an issue of getting the script in the acceptable format as highlighted here but it seems to still not be working. Could you possibly assist by putting your sample code in a format that works as a custom Script Report ? A working sample is all I need, regardless of how basic it is

Thanks plenty