사용 방법
- 설치 명령을 복사하고 자신의 에이전트 환경에 설치하기 전에 소스 패키지를 확인하세요.
- 필요한 도구, 인증 정보, 지원 환경은 원본 문서에서 확인하세요.
- 입력과 원하는 산출물을 설명하고 출처와 결과를 대조하세요.
npx skills add https://github.com/sbknext/forge-frappe-skill --skill frappe-report-development시작 전 확인
- 설치에는 모델 구독, API 한도, 파일 접근 권한이 포함되지 않습니다.
- 별점 수와 설치 수는 활동 지표이며 독립적인 품질·보안 검증이 아닙니다.
원본 저장소의 제목, 예시, 코드, 표, 링크, 이미지를 유지해 표시합니다.
Frappe Report Development
Three report types: Report Builder (no code, UI), Query Report (one SQL), Script Report (Python, full control). Use Query for simple tabular, Script for computed/multi-step.
Query Report
Create a Report (type = Query Report), put SQL in the query box. Filters are referenced as %(key)s:
SELECT
so.name AS "Order:Link/Sales Order:160",
so.customer AS "Customer:Link/Customer:200",
so.grand_total AS "Total:Currency:120"
FROM `tabSales Order` so
WHERE so.docstatus = 1
AND so.company = %(company)s
AND so.transaction_date BETWEEN %(from_date)s AND %(to_date)s
ORDER BY so.transaction_dateColumn header syntax: Label:Fieldtype/Options:Width. Filters injected as named %(...)s params — safe.
Script Report
# myapp/myapp/report/order_summary/order_summary.py
import frappe
def execute(filters=None):
filters = filters or {}
columns = [
{"label": "Customer", "fieldname": "customer", "fieldtype": "Link", "options": "Customer", "width": 200},
{"label": "Total", "fieldname": "total", "fieldtype": "Currency", "width": 120},
]
rows = frappe.db.sql("""
SELECT customer, SUM(grand_total) AS total
FROM `tabSales Order`
WHERE docstatus = 1 AND company = %(company)s
GROUP BY customer
""", filters, as_dict=True)
chart = {
"data": {"labels": [r.customer for r in rows],
"datasets": [{"values": [r.total for r in rows]}]},
"type": "bar",
}
return columns, rows, None, chart # columns, data, message, chart, report_summaryFilters (report .js)
frappe.query_reports["Order Summary"] = {
filters: [
{ fieldname: "company", label: "Company", fieldtype: "Link", options: "Company", reqd: 1 },
{ fieldname: "from_date", label: "From", fieldtype: "Date", default: frappe.datetime.month_start() },
{ fieldname: "to_date", label: "To", fieldtype: "Date", default: frappe.datetime.get_today() },
],
formatter(value, row, column, data, default_formatter) {
value = default_formatter(value, row, column, data);
if (column.fieldname === "total" && data.total > 100000)
value = `<span style="color:green">${value}</span>`;
return value;
},
};Rules
- Query Reports: only
%(name)sparams — never string-concat filter values (injection). - Set report roles so only intended users can run/export it.
- Heavy aggregations → add indexes, or precompute into a summary DocType refreshed by a scheduler job.
- Return a
chartdict for a built-in visualization;report_summaryfor top KPI cards. - For huge exports, prefer a background job writing a file over a synchronous report run.
- Report print formats: drop
{report_name}.htmlbeside the report.py/.js— client-side microtemplating (not Jinja); data available asdata,filters,report.
Source: https://docs.frappe.io/framework/user/en/desk/printing , https://docs.frappe.io/framework/user/en/guides/reports-and-printing/print-format-for-reports