How to restric a normal user to use this pick column feature in Erpnext Report.
And Also the Add Column inside Reports
If you don’t want normal users to play around with the report layout, change their permissions so they can only view the report, not customize it.
What you need to do:
-
First, create a custom role.
Go to the Roles list, click “New,” and create a role like “Report View Only.”
Save it. This role will be used only to control access to that report. -
Assign this custom role to your specific report.
Open the report, go to the Roles section, and add your new role there.
If needed, remove other roles so only selected users can access it. -
Now make this role read-only.
Open Role Permissions Manager, select the “Report” doctype, find your custom role, and give it only Read permission.
Remove Write, Customize, and any other permissions.
After doing this, the user will be able to open and view the report, but they won’t be able to change columns or customize anything. The report layout will stay exactly as you designed it.