Custom Report with dynamic Total Amount

ERPNext Reports
1

I developed a custom report from Query report which calculates and display total amount in sales invoice. It is good but the total is disappearing when ever i filter the table/view based on the data in the fields. I need the total raw to stay and calculate accordingly like in an excel sheet. Is there a better way of doing it. I searched on the Forum but got no satisfactory examples. Please forward your help. It is crucial.

2

@khaludi2 can you share your report. Can’t help unless we can see what you are doing.

3

Total is displayed before filtering

Total befor filter.png820×820 91 KB

Total value disappeared after filtering
No Total after filter.png797×797 82 KB

4

Are you adding the total cient side or server side. Obviously server side won’t work. Also its best to share your code!

5

This is my modified SQL code.

SELECT SalesInvoice as “Sales Invoice:Link/Sales Invoice:100”,Customer,Aging_date,outstanding_amount FROM labora.local.ReceivablePPLC
union all
select null,null,null,sum(outstanding_amount) as outstanding_amount
from labora.local.ReceivablePPLC;

6

Filtering is done client side, you will have to write a client side handler for slickgrid after the filter is executed.

7

Is there any example of this anywhere?