Try ERPNext Buy Support Partners Foundation

Freezing Columns in Report

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.

1 Like

What’s ur erpnext version ?

Version 10.1.20

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:
https://github.com/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.

3 Likes

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

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

Will the Datagrid have frozen columns?

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

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

is this the datatable erpnext is using?

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.

3 Likes

Erpnext using this one https://frappe.io/datatable . It’s built from scratch by frappe team.

1 Like