reports

Create a Report document with Type set to Script Report and Is Standard set to Yes, then add a report folder in your app's module containing report_name.json, report_name.py, and report_name.js files. The Python file defines an execute(filters) function returning columns and data.

Query Reports use a single SQL query stored in the database and suit direct queries with joins and aggregations. Script Reports use Python for complex data logic and JavaScript for custom filters and formatters, and are bundled with apps for version control.

Define filters in the Report document or JS file, then reference them in SQL using %(filter_name)s parameter syntax. Wrap optional conditions in Jinja-style {% if filters.name %} blocks so they only apply when the filter has a value.

Standard reports not appearing usually indicate an incorrect module path or missing is_standard setting in the report JSON. Run bench migrate to sync the report files from your app into the site's database.

Use parameterized queries with %(filter_name)s placeholders or frappe.db.escape() for user input instead of string concatenation. Frappe's database layer then safely escapes values before executing the query.

Yes, return a chart dictionary as the fourth element from the execute function alongside columns and data. The chart object specifies labels, datasets, and a type such as bar, which Frappe renders above the report grid.