skills.rest
ATXINVOX
ATXINVOXOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Generate Frappe Report

Generate custom Frappe reports using SQL query and Python script reports.

Updated Aug 27, 2026
Search Tags:#dashboard#reporting#data-analysis#generate#report#frappe
One-click install
npx skills add https://github.com/ATXINVOX/frappe-microservices-poc --skill generate-frappe-report
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Generate Frappe Report
Source: https://github.com/ATXINVOX/frappe-microservices-poc/tree/main/.cursor/skills/generate-report
Command: npx skills add https://github.com/ATXINVOX/frappe-microservices-poc --skill generate-frappe-report

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Generate custom reports for data analysis, dashboards, and business intelligence in Frappe by combining SQL-based query reports with Python-based script reports, reducing manual reporting effort.

Core Features & Use Cases

  • Supports Query Reports (SQL-based) for fast analytics.
  • Supports Script Reports (Python-based) for flexible logic and dynamic columns.
  • Provides templates and guidance for common reporting scenarios like sales analytics and operational dashboards.

Quick Start

Create a sample Frappe report that analyzes sales by customer for the last month.

Frequently Asked Questions about Generate Frappe Report

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

FAQPage Schema
How do I create a custom Frappe report for sales analytics?▼

Generating custom Frappe reports for sales analytics is automated by combining SQL-driven query reports with Python-based script reports, providing configurable filters, columns, and aggregations to reduce manual reporting effort.

What is the difference between Frappe query reports and script reports?▼

Frappe query reports are SQL-based for fast analytics, while script reports are Python-based to enable flexible logic and dynamic columns for generating business intelligence insights.

Can I add charts and summaries to a Python script report in Frappe?▼

Generating a Python script report in Frappe supports optional charts and summaries alongside configurable filters and columns, enabling comprehensive operational dashboards and data analysis.

Does this approach support generating operational dashboards in Frappe?▼

Generating operational dashboards in Frappe is supported through templates applying SQL and Python reporting techniques to operations data, enabling configurable filters, aggregations, and insights.

What's the best way to build financial reports in Frappe without manual SQL?▼

Building financial reports in Frappe without manual SQL is achieved using automated report generation combining SQL query reports and Python scripts to configure filters, columns, and aggregations.

Related Skills

Explore More Data & Analytics Skills→
grafanagrafana
213

cue-kind-definition

Define and version CUE kinds for Grafana App SDK projects.

Official
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
puzzo-devpuzzo-dev

frappe-desk

Customize Frappe Desk workspaces, reports, portal pages, and Vue.js integrations.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-analytics-reporter

Analyze data, build statistical models, and generate business intelligence reports.

Community
Advanced