frappe-syntax-reports
Installation
SKILL.md
Reports: Query, Script & Report Builder
Quick Reference
Report Types at a Glance
| Type | Code Required | Use Case | Permission |
|---|---|---|---|
| Report Builder | None | Simple single-DocType listing with filters, group by | Any user |
| Query Report | SQL only | Direct SQL queries, legacy column format | System Manager |
| Script Report (Standard) | Python + JS | Complex logic, charts, summaries, trees | Administrator + Developer Mode |
| Script Report (Custom) | Python in UI | Quick custom reports without app deployment | System Manager |
Script Report execute() Return Values
def execute(filters=None):
columns = [...] # List of dicts
data = [...] # List of dicts or lists
Related skills