"COUNT=" or "SUM=" in Detail and Summary Reports

PHPMaker General Discussion (PHPMaker)
1

Hi all,We have a project using phpmaker2021. There is a detail and summary report page that shows count and sum for some columns with “skip null/0” checked. It shows summary at a group level. For those columns with 0 count, it shows “COUNT=” or “SUM=”. Is there a way to hide “COUNT=” or “SUM=” if the count is 0?Thanks.

2

There is no such option, but you may use jQuery or JavaScript to check content of span.ew-aggregate-value and if 0, find the closest and empty the content.

3

Thanks,It works on the reports when users view it on the browser. But when they export it to Excel, it still shows “COUNT=” or “SUM=”.

4

You may see https://discourse.hkvstore.com/t/customizing-export-v2021/4020/1 To customize the value, you may override the exportAggregate() method.

5

Thanks.