frappe-report-generator

Generate custom Frappe reports using Query Reports for SQL-based data retrieval or Script Reports for Python logic. Both support dynamic filters, configurable columns, and access to the Frappe ORM, eliminating the need to write queries manually for most use cases.

Yes. Generate Query or Script Reports with dynamic filters, custom columns, and chart support. Script Reports specifically enable complex summaries and visualizations like bar charts and summary cards for dashboards.

Generate Query Reports using SQL with query optimization, database indexing, and caching best practices. SQL-based reports outperform Python scripts for high-volume data; the Skill includes performance patterns for fast report load times.

Script Reports require Python for complex logic and summaries, but the Skill includes patterns and examples. For simpler reporting, use Query Reports with SQL instead, or leverage the no-code Report Builder with configurable columns and filters.

Generate Script Reports or Query Reports with grouped columns and aggregate functions. Script Reports enable custom Python logic for calculations; Query Reports use SQL GROUP BY clauses for efficient grouping and summaries.

Generate reports with standard output formats and dynamic column structures compatible with BI workflows. The Skill outputs data suitable for export and integration with downstream analytics and reporting systems.