frappe-report-generator

What problem does it solve?

Creating custom data analysis and business intelligence reports in Frappe often requires writing complex SQL queries or Python scripts, which can be time-consuming and require specialized knowledge. This Skill automates report generation.

Core Features & Use Cases

• Query & Script Reports: Generate both SQL-based (Query Reports) for high performance and Python-based (Script Reports) for complex logic, charts, and summaries.
• Dynamic Filters & Columns: Implement flexible report filters and dynamically generated columns for adaptable data views.
• Performance Optimization: Include best practices for query optimization, database indexing, and caching to ensure reports load quickly.
• Use Case: Generate a monthly sales trend report grouped by customer, including a bar chart and summary cards for total revenue and average order value.

Quick Start

Create a Frappe Query Report to show all 'Sales Order' documents, including customer name, posting date, and grand total, with filters for date range and customer.