report-expert

To create a Frappe Script Report, use a scaffold with a basic execute function, define representative columns, and apply standard filters to establish a reliable reporting pattern.

Frappe Query Reports use direct SQL queries for data retrieval, while Script Reports execute Python functions, offering greater flexibility for complex logic and data manipulation.

The best way to structure maintainable Frappe reports is by applying consolidated best practices and standardized patterns for report types, ensuring consistent columns, filters, and workflows.

Frappe reports return inconsistent data or fail due to poorly structured queries or scripts; use the provided debugging workflows and troubleshooting patterns to identify and resolve logic errors.

The Frappe Report Builder allows you to generate custom reports with standard filters, but complex logic often requires transitioning to Query Reports or Script Reports for advanced filtering.

To add charts to Frappe Script Reports, implement the chart generation logic within your Python execute function using established patterns to render and visualize the report data.