How to restrict the Add Total Row feature in a Script Report to apply only to a specific column?

Good morning frappers,

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?

Any help would be greatly appreciated.

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.

1 Like

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.

image

Set the fieldtype → Data and remove the options.

3 Likes