How to create print format for query report

Abdeali · January 2, 2026, 5:50am

You will get this objects in report template:

    		const content = frappe.render_template(template, {
			title: __(this.report_name),
			subtitle: print_settings?.include_filters ? filters_html : null,
			filters: applied_filters,
			data: data,
			original_data: this.data,
			columns: columns,
			report: this,
		});

Reference:

github.com/frappe/erpnext

erpnext/accounts/report/financial_statements.html

develop

{%
	var report_columns = report.get_columns_for_print();
	report_columns = report_columns.filter(col => !col.hidden);

	if (report_columns.length > 8) {
		frappe.throw(__("Too many columns. Export the report and print it using a spreadsheet application."));
	}
%}

<style>
	.financial-statements-important td {
		font-weight: bold;
	}

	.financial-statements-blank-row td {
		height: 37px;
	}
</style>

<h2 class="text-center">{%= __(report.report_name) %}</h2>

This file has been truncated. show original

When Printing/PDF a report:

Default Frappe Template:

github.com/frappe/frappe

frappe/public/js/frappe/views/reports/print_grid.html

develop

<!-- title -->
{% if title %}
<h2>{{ __(title) }}</h2>
<hr>
{% endif %}
{% if subtitle %}
	{{ subtitle }}
	<hr>
{% endif %}
<table class="table table-bordered">
	<!-- heading -->
	<thead>
		<tr>
		<th> # </th>
		{% for col in columns %}
			{% if col.name && col._id !== "_check" %}
			<th
				{% if col.minWidth %}
					style="min-width: {{ col.minWidth }}px"
				{% endif %}

This file has been truncated. show original