skills.rest
anonymousminati
anonymousminatiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

frappe-syntax-reports

Create Frappe reports with correct column formats, filters, charts, and permission-safe configuration.

Updated May 31, 2026
Search Tags:#reports#permissions#frappe#report-builder#query-report#script-report#dashboard-charts
One-click install
npx skills add https://github.com/anonymousminati/Res-POS --skill frappe-syntax-reports-anonymousminati
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: frappe-syntax-reports
Source: https://github.com/anonymousminati/Res-POS/tree/main/.claude/skills/syntax/frappe-syntax-reports
Command: npx skills add https://github.com/anonymousminati/Res-POS --skill frappe-syntax-reports-anonymousminati

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you create Frappe reports that render correctly, respect permissions, and avoid common data formatting and SQL mistakes.

Core Features & Use Cases

  • Query Reports: Write SQL-based reports with the correct legacy column alias format, safe parameterized filters, and docstatus handling.
  • Script Reports: Define Python and JavaScript report logic with proper dict-based columns, summaries, charts, and tree layouts.
  • Dashboard & Analytics Setup: Configure prepared reports, number cards, dashboard charts, and report builder views for operational reporting.
  • Use Case: Use it when building a sales, finance, or operations report that needs filters, chart data, permission-safe access, and a polished desk experience.

Quick Start

Use the frappe syntax reports skill to build a Frappe report for Sales Order revenue with safe filters, correct columns, and an optional chart.

Frequently Asked Questions about frappe-syntax-reports

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a Frappe query report with safe SQL filters and correct columns?▼

Frappe script reports require dict-based column definitions, Python and JavaScript logic, and translatable labels. Using proper dict structures ensures columns render correctly and supports summaries, charts, and tree layouts.

How do I configure Frappe dashboard charts and number cards for operational reporting?▼

Configuring Frappe dashboard charts and number cards requires matching chart datasets and a valid Reference DocType. This setup ensures your analytics render correctly and maintain permission-safe access for operational reporting.

Why are my Frappe report columns not rendering correctly?▼

Frappe report columns fail to render correctly when using incorrect formats, such as non-dict-based columns in script reports or mismatched legacy aliases in query reports. Applying proper translatable labels and dict-based definitions fixes rendering issues.

Do I need a valid Reference DocType to set up Frappe dashboard charts?▼

Yes, you need a valid Reference DocType to set up Frappe dashboard charts. Matching chart datasets with a valid Reference DocType ensures permission-safe access and correct data visualization across your desk environment.

Related Skills

Explore More Software Engineering Skills→
OpenAEC-FoundationOpenAEC-Foundation
163

frappe-core-permissions

Define and enforce a five-layer access control model in Frappe apps.

Official
Advanced
Venkateshvenki404224Venkateshvenki404224
25

frappe-report-generator

Generate SQL-based and Python-based custom reports for Frappe applications.

Community
Intermediate
lubusINlubusIN
48

frappe-desk-customization

Automate Frappe Desk UI customization with form scripts, list scripts, and dialogs.

Official
Intermediate
kehwarkehwar

report-expert

Guide developers in designing Frappe reports across Report Builder, Query, and Script Reports.

Community
Advanced