Frappe Report Expert

This skill provides comprehensive guidance for working with Frappe reports, their structure, creation workflow, and best practices.

Overview

Frappe provides a powerful reporting framework with multiple report types for different use cases:

• Report Builder: Visual report builder without code (uses DocType fields)
• Query Report: SQL-based reports with direct database queries
• Script Report: Python-based reports with full programmatic control (most flexible)
• Custom Report: Customized version of an existing report

This skill focuses primarily on Script Reports as they are the most commonly created programmatically and offer the most flexibility.

Quick Reference

Report Types Comparison