ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Freezing Columns in Report

customization

#1

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.


#2

What’s ur erpnext version ?


#3

Version 10.1.20


#4

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.


[Custom] Freeze Column in Query Report, Other Query Report's Dynamic Link no longer clickable
#5

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


#6

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


#7

Will the Datagrid have frozen columns?


#8

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