Freezing Columns in Report

Vaibhavi · November 20, 2018, 5:08pm

I want to freeze the first two columns of a report when scrolling horizontally and vertically.

I implemented this. But it is getting possible only for those no of rows which are visible initially for the first time (without scrolling).
But when we scroll down columns are not visible.

5bf440d00d95d840277763

I want the first two columns of a report freeze when scrolling horizontally.
And also when scrolling vertically, one should get respective data of particular column.

Thank You.

magic-overflow · November 21, 2018, 3:09am

What’s ur erpnext version ?

Vaibhavi · November 26, 2018, 9:25am

Version 10.1.20

magic-overflow · November 26, 2018, 10:01am

I have made it worked.
Here’s my approach.

first backup slickgrid:
frappe-bench/apps/frappe/frappe/public/js/lib/slickgrid

then use my slickgrid repos instead:
GitHub - magic-overflow/slickgrid

I made changes on frappe-bench/apps/frappe/frappe/public/js/frappe/views/reports/query_reports.js to have option to freeze column. Please find change below.

github.com

magic-overflow/test/blob/master/query_report.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// MIT License. See license.txt

frappe.provide("frappe.views");
frappe.provide("frappe.query_reports");
frappe.provide("frappe.ui.graphs");

frappe.standard_pages["query-report"] = function() {
	var wrapper = frappe.container.add_page('query-report');

	frappe.ui.make_app_page({
		parent: wrapper,
		title: __('Query Report'),
		single_column: true,
	});

	frappe.query_report = new frappe.views.QueryReport({
		parent: wrapper,
	});

This file has been truncated. show original

adam26d · November 27, 2018, 6:22pm

Please make a pull request or package this as an app. Great work!

magic-overflow · November 29, 2018, 7:50am

I think frappe team will replace slickgrid with datagrid in v10 once v11 stable.

adam26d · November 29, 2018, 12:30pm

Will the Datagrid have frozen columns?

magic-overflow · November 29, 2018, 12:49pm

Sorry, not datagrid, it’s datatable. It will have in future as this feature in development plan.

johnskywalker · October 17, 2020, 8:18am

https://datatables.net/extensions/fixedcolumns/examples/initialisation/two_columns.html

is this the datatable erpnext is using?

federico_calvo · October 17, 2020, 1:26pm

interesting. I never understood why this functionality was not given priority, which should not be very difficult to implement, there are several posts about it.

Many reports are practically unreadable without being able to do this.

magic-overflow · October 22, 2020, 11:11am

Erpnext using this one Frappe DataTable - A simple, modern datatable library for the web . It’s built from scratch by frappe team.

Birendra_Bhujel · April 8, 2021, 11:45am

@magic-overflow I implemented as per your guide but there is no effect in the columns. I want to freeze particular column while scrolling horizontally in the report.