I’m working on a Script Report where checking the “Add Total Row” also sums the ID column, which is an auto-increment field. I want to apply the sum to all columns except the ID column. Is there a way to exclude the ID column from the sum or to hide its total using CSS?
The behavior is awkward because I included a link in the ID column for customers to click and access the original record. However, the hyperlink also appears in the sum section, where no corresponding record exists. Is there a way to at least disable the link functionality in this situation?
If you create a custom script report and need to remove the totals from specific columns, delete the Float/Int/Currency from those columns, then reload and check.
It’s a browser functionality, not a erpnext functionality. go to the browser and Hover your cursor over the website link and it will automatically show the reference link below.
Hi @NCP, thanks for your response. You’re correct that this is a custom app and involves script reporting. The screenshot below illustrates the definition of the Id column, where the field type is set as LINK. Is there a place where I can specify the data type? It appears to automatically recognize the data type as Int and apply the sum functionality.