Report not loading

ERPNext
,
1

Why the below script is not working? My ERP is hosted on frappe cloud. I do not have access to the backend files. I’m trying to create report using Report>>New Report>>Script Report>>Is Standard = No

def execute(filters=None):
    columns = [
        {
            "fieldname": "owner",
            "label": "Owner",
            "fieldtype": "Data",
            "width": 120
        },
        {
            "fieldname": "status",
            "label": "Status",
            "fieldtype": "Select",
            "width": 100
        }
    ]

    # Make sure that the fields in the get_all call match those defined in the columns.
    data = frappe.get_all("Attendance", fields=["owner", "status"])

    return columns, data

‘Show Report’ is blank.

2

Please see what I’ve learned here.

Your code is written as if it’s going in the backend. I’m not a programmer so I can’t say exactly what’s wrong. There’s a description from Gemini after battling this topic for hours. Please follow the link in my post for the Gemini discussion. Search for “this works” or “basic example”.