How to create print format for query report

dynovative · January 1, 2026, 11:39am

HI there does anybody knows how to create print format for query report i am create reports for school

ahsantareen · January 1, 2026, 1:00pm

Query Report does not offer print formats.

You can create custom doctype and render data in child tables which then can be handled easily for report print formatting by working with either Print Format Builder or writing custom html as well.

dynovative · January 1, 2026, 1:02pm

can you guide me little more please

Abdeali · January 2, 2026, 5:47am

Hello,

You can create a print fomat for report as well.

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

dynovative · January 5, 2026, 5:20am

I hae question i tried from this method does i have to write print format but not in file code i have set format type js and write jinja code in ui area not backend files

@ahsantareen @Abdeali

Abdeali · January 5, 2026, 6:14am

Yes! Not require to write in files, If it is not standard.