Show data in script report

1

i have this script , when i implemented it there is no data to show i just see this massage ‘Nothing to show’

my code

def fetch_sales_incentives():
    return frappe.db.sql("""
        SELECT 
            e.employee AS Sales_Officer,
            COALESCE(sp.sales_person, 'N/A') AS Sales_Person,
            e.designation AS Designation,
            e.custom_related_business AS Related_Business,
            COALESCE(i.incentive_amount, 0) AS Incentive_Amount,
            i.date AS Incentive_Date
        FROM
            `tabIncentives` i
        LEFT JOIN
            `tabSales Team` st ON st.name = i.sales_team
        LEFT JOIN
            `tabSales Person` sp ON sp.name = st.sales_person
        LEFT JOIN 
            `tabEmployee` e ON e.employee = sp.employee
        WHERE
            e.designation = 'Sales Officer'
        ORDER BY 
            i.date DESC
    """, as_dict=True)

def execute(filters=None):
    data = fetch_sales_incentives()
    columns = [
        {"fieldname": "Sales_Officer", "label": _("Sales Officer"), "fieldtype": "Data", "width": 150},
        {"fieldname": "Sales_Person", "label": _("Sales Person"), "fieldtype": "Data", "width": 150},
        {"fieldname": "Designation", "label": _("Designation"), "fieldtype": "Data", "width": 150},
        {"fieldname": "Related_Business", "label": _("Related Business"), "fieldtype": "Data", "width": 150},
        {"fieldname": "Incentive_Amount", "label": _("Incentive Amount"), "fieldtype": "Currency", "width": 100},
        {"fieldname": "Incentive_Date", "label": _("Incentive Date"), "fieldtype": "Date", "width": 100},
    ]
    return columns, data
2

Please check the second video: Create scripts report error - #2 by NCP

3

But i Don’t Have source code , i only use user interface.
can i use functions and appearing the result in the manually report columns.?

4

For that, use a simple query report. A server script report is harder to develop from the UI side. If you need to write complex logic and create a more advanced report, then use the server script and build it in your custom app.

If you want to develop a query report, you can check this reference: I need script report or query report for lead transaction - #6 by NCP

5

if i use Script Report can i make functions? to get data and show the result in the Report Inter face by using UI Side?

6

Please check the reference: How to apply filters for query report - #3 by NCP

Already told to you, you can’t define the method from UI side.

7

i can set methods in script report from UI Side and i can show result in a massage only, but i cant show the result in the report interface